Sql Hints

Yii 1.1 General Discussion
1

I’ve done several search on here and the google and can’t find anything referencing the ability or lack there of for sql hints. In particular I hit a rather busy database where the data I’m pulling back really doesn’t need locking so a dirty ready is fine and much faster but I don’t see any method for adding “WITH (NOLOCK)” hint to table joins. Is this something possible and I’m just googling for the answer wrong or is it something nobody else does?

Thanks!

2

AFAIK such features are not supported by Yii, same as switching from UNION to UNION ALL to skip sorting and duplicate removal.

You’d have to extend the CDb* family classes to implement that.