First page Back Continue Last page Graphics
SQL Profiles
Additional statistics and information for CBO
Changes normal decision of CBO at run-time
- Sort of like a hint
- Without specifying the hint
- Useful for packaged apps?
Created - when warranted - by SQL Tuning Advisor
- When run in COMPREHENSIVE mode
- Stored in dictionary
Don’t confuse with stored outlines
- Profile can change over time
Notes:
An SQL Profile is a mechanism used to affect to plan chosen by CBO. When needed, SQL Profiles are created by the SQL Tuning Advisor.
Source: Metalink Note 271196.1