What happens when you run the SQL Tuning Advisor with l…

What happens when you run the SQL Tuning Advisor with limited scope?

What happens when you run the SQL Tuning Advisor with limited scope?

A.
Access path analysis is not performed for SQL statements.

B.
SQL structure analysis is not performed for SQL statements.

C.
SQL Profile recommendations are not generated for SQL statements.

D.
Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.



Leave a Reply 0

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