|
TMyServerControl.AnalyzeTable Method |
|
|
|
TMyServerControl.AnalyzeTable Method |
|
Analyzes and stores the key distribution for the table
procedure AnalyzeTable;
Call the AnalyzeTable method to analyze and store the key distribution for the table. During the analysis, the table is locked with a read lock. This works on MyISAM and BDB tables.
This is equivalent to running myisamchk -a on the table.
If the table hasn't changed since the last AnalyzeTable command, the table will not be analysed again.
The list of the tables is used from TableNames.
Refer to the ANALYZE TABLE detailed description at MySQL Reference Manual.