EXPLAIN

EXPLAIN

EXPLAIN table_name EXPLAIN select_query

The select_query is the same as specified in the SELECT description.

Using EXPLAIN with a table name is a synonym for DESCRIBE table_name. Using EXPLAIN with a query provides feedback about how the query will be executed, which is useful for optimizing the query and making the best use of the associated indexes.



Mastering MySQL 4
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors: Ian Gilfillan

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net