Viewing the Plan Control

The Plan Control subpage contains information about the following items:

• SQL profiles

  A SQL profile contains additional statistics for the SQL statement. The optimizer uses these statistics to generate a better execution plan for the statement.

• SQL patches

  A SQL patch is automatically generated to work around an error or performance problem for a single SQL statement.

• SQL plan baselines

  A SQL plan baseline is an execution plan proven to have acceptable performance for a given SQL statement.

To view plan control information: 

1. On the SQL Details page, under Details, click Plan Control.

   The SQL Details page appears, showing the Plan Control subpage.

2. Review the plan-related information.