The central idea behind “swapping” SQL profiles is simple.Β Β You define a SQL profile that specifies the SQL statement that you want to tune, and an…
View More How to Swap SQL_Profiles?
Tag: query optimizer
SQL Profiles in the Data Dictionary
In the paper SQL Profiles (page 22) I described the data dictionary tables where the hints belonging to SQL profiles are stored. For example, with the following…
View More SQL Profiles in the Data Dictionary