Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?

Which of the following advisors within the Oracle advisory framework will analyze a single
SQL statement and make recommendations for performance improvement?

Which of the following advisors within the Oracle advisory framework will analyze a single
SQL statement and make recommendations for performance improvement?

A.
SQL Repair Advisor

B.
SQL Optimizer

C.
SQL Access Advisor

D.
SQL Tuning Advisor

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

Eamon

Eamon

In my opinion …
SQL Access Advisor is also part of the advisor framework, however it is the SQL Tuning Advisor that makes recommendations for performance improvements. Then any recommended index or other object (e.g. index, MV, partitioning or the use of ASSM) should be checked with the SQL Access Advisor over a workload (a set of SQL statements, not just one SQL) to determine whether there is a net gain in performance.
So yes, I agree with the answer above.

Reply