Viewing a SQL query execution plan enables you to analyze query run time and cost to ensure that your queries run as efficiently as possible.

You are logged in to Data Director as a user with appropriate privileges on the database or schema.

You know how to enter and run a SQL query. See Enter and Run a SQL Query.

1

Click the Manage & Monitor tab and select the schema for which you want to view a query pane.

2

Select the schema, and click Enter SQL.

3

Enter a SQL query in the entry pane, or click Open to open a SQL script file.

4

Click Execute to run the query.

5

Click Explain to view the query plan, run time, and CPU cost.

Adjust the SQL query, rerun, and reexamine the query plan as necessary to tune performance.