MySQL Forums
Forum List  »  Newbie

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.

Options: ReplyQuote


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.