| Title | Description |
|---|---|
| ANALYZE FORMAT=JSON | Mix of the EXPLAIN FORMAT=JSON and ANALYZE statement features. |
| ANALYZE FORMAT=JSON Examples | Examples with ANALYZE FORMAT=JSON. |
| ANALYZE Statement | Invokes the optimizer, executes the statement, and then produces EXPLAIN output. |
| EXPLAIN | EXPLAIN returns information about index usage, as well as being a synonym for DESCRIBE |
| EXPLAIN ANALYZE | Old implementation, now ANALYZE statement |
| EXPLAIN FORMAT=JSON | Variant of EXPLAIN that produces output in JSON form |
| SHOW EXPLAIN | Shows an execution plan for a running query |
| Using Buffer UPDATE Algorithm | Explanation of UPDATE's "Using Buffer" algorithm |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/analyze-and-explain-statements/