On-line Documentation

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.