from the Artful MySQL Tips List
Explain [extended] lays out the optimiser's execution plan for a query. Since version 5.6.3, turning on the optimiser trace facility for a session can show alternative plans that the optimiser considered ...
The next query is written to
information_schema.optimizer_trace.query, the optimizer trace is written to
information_schema.optimizer_trace.missing_bytes_beyond_max_mem_size is not empty, increase available memory for the trace ...
and run the query again.
Remember to turn tracing off when you're done.
Return to the Artful MySQL Tips page