Hello! My Mysql version is 3.23.56. I want to use specific index, but when I use "use index" EXPLAIN gives me that key not used. And when I'don use "use index" mysql uses other index. Where I test this in 4.0.14 with force index it works and the query time is 4x faster with index I choose, then the index mysql use.
Is anybody can tell me how to fix this problem. May be the way(sequence) of creating indexes has matter? Thank you! Kosyo __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
