Accessing query plans in Management Console

You can access query plans in Management Console in two ways:

• In the Detail page for query-related charts on the database's Activity page, click Explain next to a query to view a plan for that query.

• Enter a query manually on the Explain page and click Explain Plan.

In both cases, the following window opens:

You can also enter the transaction ID and statement ID or browse running or completed queries in the Find a Query input window:

In the output window, you can perform the following tasks related to the query you entered:

• Expand and collapse query paths.

• Clearing query data.

• View projection and column metadata.

• Use different query plan views.