Page 1 of 1

Optimizing LEFT JOIN

Posted: Sat Mar 04, 2006 12:21 am
by anjanesh
My SQL query containing a LEFT JOIN is taking over 2 mins to finish.
I have id as PRIMARY, col2 as UNIQUE and col3 as INDEX - still i takes so much time - I added col3 as INDEX just to see if the time taken is less for the LEFT JOIN query but isnt.

Any other way to optimize the query ?

Thanks

Posted: Sat Mar 04, 2006 12:24 am
by feyd
use EXPLAIN to help you determine how fields are being used.