Is it possible to use in Yii model oracle hints, something like this:
$criteria = new CDbCriteria();
$criteria->select = array('/*+ index(t INDX_NAME_1) */ first_name, id ');
...
$criteria->order = 'first_name DESC';
$criteria->limit = 10;
$items = Data::model()->find($criteria);
I try with:
$criteria->select = new CDbExpression('/*+ index(t INDX_NAME_1) */');
any idea?