The Database Query Execution Plan window can help you to determine the most efficient execution plan for your queries. Once you've discovered a potentially problematic query, you can run the EXPLAIN PLAN statement to check the execution plan that the database created. A query's execution plan reveals whether the query is optimizing its use of indexes and executing efficiently. This information is useful for troubleshooting queries that are executing slowly.
Access the Database Query Execution Plan Window
To access the Database Query Execution Plan Window
- To view a query execution plan, click the name of the database.
- Click the Queries tab.
- Click a SELECT statement you want to examine and click View Query Details.
- Click the Execution Plan tab.
Features of the Database Query Execution Plan Window
On the Database Query Execution Plan window, you can take the following actions:
- Click Explain to view the execution plan for a query.
- Click Schema to choose a different schema and then explain the execution plan based on that schema. If you want to view the execution plan for a query that belongs to a schema outside the scope of your database account permissions, you can enter a username and password for a different database account that has access to the schema.
- If you want to improve a suboptimal query, you can modify the query and paste it into the Explain another query box. Click the Explain button to generate the execution plan for your modified query and determine whether the modified query is more efficient.
- Click the down arrow next to the query name at the top of the page to choose to view queries and query execution plans of a different database Collector. You can either select the database Collector name from the list or search for the database Collector in the search bar. Click the refresh icon to show only database Collectors that meet your search criteria.
If you are using Oracle, SQL Server or Azure you can view the execution plan in one of the following ways:
- Select a cached execution plan and click View Cached Plan to view the plan details.
- Double-click a cached execution plan.
If you are using MySQL, you can also take the following actions:
- Choose to explain the query on another schema. In Plan Details, from the list on the right, choose the schema name and then click EXPLAIN.
- Copy the text in the Parsed SQL output box and paste it into the Explain another query box where you can edit it and then explain the edited version of the query.
On the Database Query Execution Plan window you can see the following information:
- Cached Execution Plan(s): identifying details of the cached execution plan, which vary from one database to another. For SQL Server, the execution plan is rendered as a diagram.
- Plan Details: execution plan details, showing the step by step procedure the database followed to process the selected query.
- Referenced Objects: the database objects accessed by the execution plan.