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.







Full version (for Windows)


Lite version (for Windows)


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