Online Documentation for SQL Manager for Oracle

Control 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.