Re: help with optimize a query plzzzz.....
Posted by:
Arie Nagel
Date: August 17, 2005 01:37PM
I think the optimizer decided that a table scan would be faster for the first query and the index would be faster (or less costly) for the second query.
See:
http://dev.mysql.com/doc/mysql/en/mysql-indexes.html
Maybe a real optimisation guru could offer his/her opinion?
Or you might try posting this in the performance-forum on this site...
Hope this helps.
Subject
Written By
Posted
Re: help with optimize a query plzzzz.....
August 17, 2005 01:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.