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.

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback