MyDAC

TMyServerControl.AnalyzeTable Method

Analyzes and stores the key distribution for the table

Class

TMyServerControl

Syntax

procedure AnalyzeTable;

Remarks

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-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback