EMS logo

Produkt Navigation

SQL Manager for MySQL

Unsere Partnerschaften

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for MySQL

Online Bedienungsanleitung

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.



See also:


Using templates