4

Is there a way to generate a list of JOINS being performed without indexes in MySQL?

1 Answer 1

4

If you have available a list of SELECT queries your application performs, just put log-queries-not-using-indexes in your my.cnf, restart MySQL and execute all the SELECTs. Then read the log file.

Alternatively you can run EXPLAIN SELECT your_query_using_JOIN and read the output.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .