Re: MySQL can't find index = really slow query...

[Bob Field]

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.