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 | 
Analyze Tables... main menu item.
|
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. |
|
|
See also: |