|
1994.5.36
by Stewart Smith
add some FIXME to analyze docs. |
1 |
ANALYZE
|
|
1887.3.2
by Brian Aker
Extended documentation. |
2 |
=======
|
3 |
||
|
1994.4.83
by Marisa Plumb
table update functions edits, starting authentication |
4 |
Syntax: ::
|
5 |
||
6 |
ANALYZE TABLE table_name [, table_name] ...
|
|
7 |
||
8 |
ANALYZE TABLE usually read locks a table, and then analyzes and stores the key distribution for a table. |
|
9 |
||
10 |
ANALYZE functionality differs depending on the storage engine. |
|
11 |
||
12 |
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 |
|
13 |
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. |
|
14 |
||
15 |
Statistics-gathering with ANALYZE has recently been added to HailDB so that index dives are performed. |