PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/explain.html
{EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name ...The description for SHOW COLUMNS provides more information about the output ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
The EXPLAIN statement provides information about how MySQL executes statements. EXPLAIN returns a row of information for each table used in the SELECT statement. Note MySQL Workbench has a Visual Explain capability that provides a visual ...It ...
https://dev.mysql.com/doc/refman/8.0/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following EXPLAIN. The extended information displayable with a SHOW WARNINGS statement ...As ...
https://dev.mysql.com/doc/refman/8.0/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
One visible effect of this change is that, for Boolean values, EXPLAIN output now shows true and false, rather than 1 and 0. This is similar to, and reuses, the existing IS NULL (Not exists) optimization for outer joins; see EXPLAIN Extra ... This ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
In MySQL 8.0.20 and later, the hash join is used in such cases, as shown here: mysql> EXPLAIN FORMAT=TREE -> SELECT * FROM t1 -> JOIN t2 ON (t1.c1 = t2.c1) -> JOIN t3 ON (t2.c1 < t3.c1)\G *************************** 1. This means that the types of ... By default, MySQL (8.0.18 and later) employs hash joins whenever ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
*/ ...) The implication is that you can use EXPLAIN to see how optimizer hints affect execution plans. Use SHOW WARNINGS immediately after EXPLAIN to see how hints are used. The extended EXPLAIN output displayed by a following SHOW WARNINGS ... One ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html
Using the statement EXPLAIN SELECT to see which partitions are used by a given SELECT. It is possible to determine which partitions of a partitioned table are involved in a given SELECT query using EXPLAIN. The partitions column in the EXPLAIN ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
Possible values and their effects are listed here: TRADITIONAL: Use MySQL's traditional table-based output, as if FORMAT=TRADITIONAL had been specified as part of the EXPLAIN statement. Note DEFAULT cannot be used as part of an EXPLAIN statement's ... The MySQL server maintains many system variables that affect its ...