Viewing query plan
Using SQL Manager for MySQL, you can view the plan for each of the queries created and executed in the application. The query plan is available within the corresponding Plan tab.
The Plan tab allows you to view the sequence of actions performed by the database server in the process of the query execution, and the amount of system resources used for the query execution.
The Plan panel displays the operations as a list with the following columns: id, select_type, table, type, possible_keys, key, key_length, ref, rows, Extra.
Click a column caption to sort items by values of this column in the ascending or the descending mode.
If necessary, you can specify that the Plan tab appears automatically upon query execution in SQL Editor: select the Explain query on execution option available within the Tools | SQL Editor section of the Environment Options dialog.