|
1994.5.36
by Stewart Smith
add some FIXME to analyze docs. |
1 |
ANALYZE
|
|
1887.3.2
by Brian Aker
Extended documentation. |
2 |
=======
|
3 |
||
4 |
ANALYZE TABLE table_name [, table_name] ... |
|
5 |
||
6 |
ANALYZE TABLE read locks a table, and then analyzes and stores the key distribution for a table. |
|
|
1994.5.36
by Stewart Smith
add some FIXME to analyze docs. |
7 |
|
|
2165.2.3
by Andrew Hutchings
Add favicon to docs |
8 |
.. todo:: |
9 |
||
10 |
is read lock always true? |
|
11 |
||
12 |
.. todo:: |
|
13 |
||
14 |
some engines don't perform an explicit gathering of statistics when |
|
15 |
you type ANALYZE. e.g. innobase (which only copies it's current estimate). |
|
16 |
Only recently did I add this to HailDB so that it does go and do the index |
|
17 |
dives on ANALYZE. |