Online Documentation for SQL Manager for MySQL

Analyze Tables


Analyze Tables Wizard allows you to analyze and store the key distribution for tables.

 

During the analysis the table is locked with a read lock (for MyISAM and BDB tables) or with a write lock (for InnoDB tables). MySQL uses the stored key distribution to decide in what order tables should be joined when one does a join on something different than a constant. In addition, key distributions can be used when deciding which indexes to use for a specific table within a query.

 

To run the wizard, select the Services | iconAnalyzeTables Analyze Tables... main menu item.

 

menuServices_AnalyzeTables

 

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.