|
1994.5.36
by Stewart Smith
add some FIXME to analyze docs. |
1 |
ANALYZE
|
|
1887.3.2
by Brian Aker
Extended documentation. |
2 |
=======
|
3 |
||
|
2194.5.2
by Andrew Hutchings
Fix SQL markup |
4 |
Syntax: |
5 |
||
6 |
.. code-block:: mysql |
|
|
1994.4.83
by Marisa Plumb
table update functions edits, starting authentication |
7 |
|
8 |
ANALYZE TABLE table_name [, table_name] ... |
|
9 |
||
10 |
ANALYZE TABLE usually read locks a table, and then analyzes and stores the key distribution for a table. |
|
11 |
||
12 |
ANALYZE functionality differs depending on the storage engine. |
|
13 |
||
14 |
On InnoDB tables, using ANALYZE will result in a WRITE LOCK on the table. It also will not perform an explicit gathering of statistics when |
|
15 |
you issue an ANALYZE command. To update the index cardinality, there will be 10 random dives into each index, retrieving an estimated cardinality. Therefore, several ANALYZE TABLEs in a row are likely to produce different results each time. |
|
16 |
||
17 |
Statistics-gathering with ANALYZE has recently been added to HailDB so that index dives are performed. |