Figuring out when a query uses an index on join

[bauhsoj]

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]

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.

[bauhsoj]

Thanks...I enabled that and will see what I can figure out.