|
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 |
|
8 |
FIXME: is read lock always true? |
|
9 |
||
10 |
FIXME: some engines don't perform an explicit gathering of statistics when |
|
11 |
you type ANALYZE. e.g. innobase (which only copies it's current estimate). |
|
12 |
Only recently did I add this to HailDB so that it does go and do the index |
|
13 |
dives on ANALYZE. |