Description of the illustration sql_details_plan_control.gif

This graphic shows the SQL Profiles and SQL Patches, and the SQL Plan Baseline sections.

The SQL Profiles and SQL Patches section has text that reads: A SQL Profile contains additional information (auxiliary statistics) that aids the optimizer to select the optimal execution plan of a particular SQL statement. A SQL Patch is automatically generated to workaround an error or performance problem for a single SQL statement.

The section has a table with the following columns: Select, Name, Type, Category, Status, Created. The table has one row with the following values: null, (No data), null, null, null, null.

The SQL Plan Baseline section has text that reads: A SQL Plan Baseline is an execution plan deemed to have acceptable performance for a given SQL statement.

The section has a table with the following columns: Select, Name, Fix, Accept, Auto Purge, Enabled, Created.

The table has one row with the following values: STMT01, NO, YES, NO, YES, Feb 12, 2012, 12:57:53 PM.