Which two are true about the SQL Tuning Advisor?

Question

Options

• AIt can recommend semantic changes to SQL statements.
• BIt prevents performance regressions for SQL statements when changes are made.
• CIt checks each query being analyzed for missing or stale statistics.
• DIt considers all SQL statements being analyzed by the advisor task as a group.
• EIt only recommends syntactic changes to SQL statements.

• A
  89% (24)
• D
  7% (2)
• E
  4% (1)

Explanation

A is correct because the SQL Tuning Advisor goes beyond surface-level formatting - it can suggest restructuring queries semantically (e.g., rewriting subqueries, adding hints, or changing join methods) to improve execution plans. C is correct because checking for missing or stale optimizer statistics is one of the advisor's four core analysis modes; stale stats are a leading cause of poor plans, so the advisor flags them explicitly.

B is wrong - preventing performance regressions is the job of SQL Plan Management (SPM) or SQL Performance Analyzer (SPA), not the Tuning Advisor. D is wrong - the Tuning Advisor analyzes each SQL statement individually; it's the SQL Access Advisor that considers a SQL workload as a group when recommending indexes or materialized views. E is wrong - it directly contradicts A; the advisor makes semantic (logical/structural) recommendations, not merely syntactic (formatting) ones.

Memory tip: The SQL Tuning Advisor is a solo doctor - it examines one patient at a time (not D), checks their stats vitals (C), and can prescribe real lifestyle changes, not just cosmetic touch-ups (A, not E). For regression prevention, think Plan Management, not Tuning.

No community discussion yet for this question.