79690

About the Automatic SQL Tuning Advisor

The SQL Tuning Advisor runs automatically during system maintcnancc Windows (time periods) as a maintcnancc task. During cach automatic run, the advisor sclects high-load SQL queries in the system and generates recommcndations on how to tunc these queries.

The Automatic SQL Tuning Advisor can be configured to automatically implement SQL profile recommcndations. A SQL profile contains additional SQL statistics that are specific to the SQL Statement and enable the query optimizer to generate a significantly better execution plan at run time. ff you enable automatic implementation. then the advisor crcatcs SQL profiles foronly thosc SQL State ment s where the performance improvement would be at least threefold. Othcr types of recommcndations. such as the creation of new indexes, refreshing optimizer statistics. or restructuring SQL, can only be implementcd manually. DML statements are not considered for tuning by the Automatic SQL Tuning Advisor.

You can view a summary of the results of automatic SQL tuning, and a detailed report about recommcndations madę for all SQL statements that the SQL Tuning Advisor has processed. You can then implement selected recommcndations. You can also view the recommcndations that were automatically implementcd.

You can disable the Automatic SQL Tuning Advisor, if desired.