Online Documentation for SQL Manager for SQL server

Control a query productivity

You can view a query productivity on the query plan. It 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.

To view the Plan of a query, open the query in Query Data and use the btnExplainQuery Show estimated execution plan item of the Navigation bar or toolbar.

If necessary, you can specify that the Plan tab appears automatically upon query execution in Query Data: select the CheckBox Show actual execution plan on query execution option available within the Tools | Query Data section of the Environment Options dialog.