Vote count:
0
I have a really large, complex query I'm trying to optimise using MySQL EXPLAIN SELECT or EXPLAIN EXTENDED SELECT.
If I run it against the query, I'll see every table in the query is using Using where in the Extra column, which is great.
No data will be changed at all, I'll go off and make a cup of tea or something, come back and re-run EXPLAIN.
This time, just a few minutes later, only 20% of the tables are Using where, the primary table is now Using index; Using temporary; Using filesort, and my day becomes a nightmare trying to debug this.
Any ideas why this would be happening? Is there logic or reason behind such a thing?!
asked 2 mins ago
MySQL EXPLAIN - it keeps giving me different explanations each time
Aucun commentaire:
Enregistrer un commentaire