Online Documentation for SQL Manager for SQL server

Просмотр плана запроса


Using SQL Manager for SQL Server, 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.

 

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

 

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.

 

Query Builder - Viewing query plan

 

При необходимости, вы можете указать, что необходимо отрывать вкладку Plan автоматически, после выполнения запроса, установив флажок CheckBox Show actual execution plan on query execution на вкладке Tools | Query Builder в Настройках окружения.