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: |