SQL Tuning Advisor:Overview
1.Detect stale or missing statistics
2.Tune SQL plan (SQL profile)
3.Add missing index
4. Restructure SQL
Automatic SQL Tuning :Overview
SQL Statement Profiling
Plan Tuning Flow and SQL Profile Creation
1.Detect stale or missing statistics
2.Tune SQL plan (SQL profile)
3.Add missing index
4. Restructure SQL
Plan Tuning Flow and SQL Profile Creation