January 2012
Intermediate to advanced
542 pages
11h 28m
English
Displays information about the SQL Plan baselines created for a specific SQL statement.
The most relevant view fields are as follows:
SQL_HANDLE: A unique identifierSQL_TEXT: The un-normalized SQL textPLAN_NAME: A unique plan identifierENABLED: This indicates whether the plan baseline is enabled (YES/NO)ACCEPTED: This indicates if the plan baseline is accepted (YES/NO)FIXED: This indicates if the plan baseline is fixed (YES/NO)EXECUTIONS: The number of executions at the time the plan baseline was createdRead now
Unlock full access