MySQL (use | force | ignore) index support

[bazilio91]

force index works only with hack:

$criteria = new CDbCriteria();
$criteria->join = " force index (`super-custom-index`) ";

but with constructions like this:

SELECT * FROM t
  USE INDEX (index1)
  IGNORE INDEX (index1) FOR ORDER BY

its useless. it looks hard to optimize selects from huge tables without index functional

some links:

http://www.yiiframework.com/forum/index.php?/topic/12545-how-do-i-perform-this-sql-search
http://www.mysqlperformanceblog.com/2007/01/31/getting-mysql-to-use-full-key-length/

[DaSourcerer]

👍

[samdark]

Won't be implemented since 1.1 is reaching EOL and new features aren't accepted.