View Full Version : Figuring out when a query uses an index on join

07-14-2006, 04:51 PM
The variable "Select_full_join" is showing a very high number when the recommendation is to have this at zero.

I can get a full list of all queries generated on the site but how do I figure out which ones aren't using an index in the join?

Kid Charming
07-14-2006, 05:21 PM
You can set up the slow query log (http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html) to indicate queries that aren't using indexes. If you've only got a few candidates, though, I'd just run them through EXPLAIN.

07-21-2006, 10:01 PM
Thanks...I enabled that and will see what I can figure out.