SQL Tuning Advisor and SQL Access Advisor are built-in tools that provide SQL tuning recommendations.

This part contains the following chapters:

• Managing SQL Tuning Sets
  You can use SQL tuning sets to group statements and related metadata into a single object, which you can use as input to SQL tuning tools.
• Analyzing SQL with SQL Tuning Advisor
  Use SQL Tuning Advisor to obtain recommendations for improving performance of high-load SQL statements, and prevent regressions by only executing optimal plans.
• Optimizing Access Paths with SQL Access Advisor
  SQL Access Advisor is diagnostic software that identifies and helps resolve SQL performance problems by recommending indexes, materialized views, materialized view logs, or partitions to create, drop, or retain.