|
The EXPLAIN statement can be used either as a synonym for DESCRIBE or as a way to obtain information about how MySQL executes a SELECT statement:
|
dev.mysql.com/doc/refman/5.0/en/using-explain.html
dev.mysql.com/doc/refman/5.0/en/using-explain.html
|
|
|
|
The EXPLAIN tbl_name syntax is synonymous with DESCRIBE tbl_name or SHOW COLUMNS FROM tbl_name. ... MySQL Optimization, part 1 - 6.2.1 EXPLAIN Syntax (Get Information About a SELECT) ... EXPLAIN Syntax (Get Information About a SELECT)
|
www.devshed.com/c/a/MySQL/MySQL-Optimization-part-1/2/
|
|
|
EXPLAIN tbl_name or EXPLAIN SELECT select_options ... When you precede a SELECT statement with the keyword EXPLAIN, MySQL explains how it would process the SELECT, providing information about how tables are joined and in which order.
|
tecfa.unige.ch/guides/mysql/man/manuel_EXPLAIN.html
tecfa.unige.ch/guides/mysql/man/manuel_EXPLAIN.html
|
|
If so, create an appropriate index and check the query with EXPLAIN again. See section 13.2.2 ALTER TABLE Syntax. To see what indexes a table has, use SHOW INDEX FROM tbl_name.
|
teaching-2.cs.uml.edu/MySQLdocs/MySQL_Manual/EXPLAIN.ht...
teaching-2.cs.uml.edu/MySQLdocs/MySQL_Manual/EXPLAIN.html
|
|
MySQL 5.1 Reference Manual :: 12 SQL Statement Syntax :: 12.3 MySQL Utility Statements :: 12.3.2 EXPLAIN Syntax ... 12.3.1 DESCRIBE Syntax ... 12.3.3 HELP Syntax...
|
library.pantek.com/Applications/MySQL/doc/refman/5.1/en...
library.pantek.com/Applications/MySQL/doc/refman/5.1/en/explain.html
|
|
It is the first manual in the market to understand the Spanish syntax in a clear and concise form. ... The book is focused to a wide public: in one hand, to language teachers who will find an easy theory to explain and a great variety of examples to use in class. And in the other hand, students will have a good handbook...
|
www.aulahispanica.com/node/289
|
|
The possible_keys column indicates which indexes MySQL could use to find the rows in this table. Note that this column is totally independent of the order of the tables as displayed in the output from EXPLAIN. ... The EXPLAIN tbl_name syntax is synonymous with DESCRIBE tbl_name or SHOW COLUMNS FROM tbl_name.
|
mysql.uahrc.se.ntou.edu.tw/doc/mysql/en/explain.html
mysql.uahrc.se.ntou.edu.tw/doc/mysql/en/explain.html
|
|
mySQL EXPLAIN syntax for MSSQL?- MS SQL Development. Visit Dev Shed to discuss mySQL EXPLAIN syntax for MSSQL? ... in mysql i used to use the EXPLAIN syntax for retrieving info from tables, selects etc, but now i was wondring if something similar exixsts for MSSQL; Thanks in advance!
|
forums.devshed.com/ms-sql-development-95/mysql-explain-...
forums.devshed.com/ms-sql-development-95/mysql-explain-syntax-for-mssql-147445.html
|
|
support the Explain syntax, which is defined and registered in Appendix 5 REC. ... A Present request for Explain records should specify the Explain syntax as the Preferred-record-syntax. Each explain information category has its own record layout, and all are described in the Explain syntax definition (see Appendix 5 REC.1).
|
www.loc.gov/z3950/agency/markup/07.html
|
|
