MySQL Forums
Forum List  »  Optimizer & Parser

Re: MySQL can't find index = really slow query...
Posted by: Bob Field
Date: September 25, 2006 09:23AM

Sometimes the ANSI syntax performs better simply by organizing the query better and giving the optimizer an easier time. I think tables a and n are the ones needing some attention. MySQL can only use one index, so you need one that can help both the selection and the joining.

I'd start with an index on affidamenti_procuratore.fine.



Edited 1 time(s). Last edit at 09/25/2006 09:25AM by Bob Field.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL can't find index = really slow query...
2281
September 25, 2006 09:23AM


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.