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.

 

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.

 

 


See also:

Tables

Using templates