----- Original Message ----- > From: "Andrés Tello" <mr.crip...@gmail.com> > > showed the usage of the index, then, some time later, it show, for > the same query, the usage of no index...
Look at the "rows" field. It's obvious that this table is live and rather on the active side; and the data has changed in such a way that on the second explain, the optimizer estimates that there would be little benefit from using that key - most likely due to cardinality. Make a copy of the table so your data is static, and you'll get the same explain every time. That will, however, apparently not simulate the real world for you. If this is a MyISAM table you may need to run ANALYZE TABLE to update the statistics; or you may just have to accept that the same query on different data may benefit from a different execution plan - just as a different query on the same data would. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
