What happens when you run the SQL Tuning Advisor with limited scope?
Posted: Wed Jun 07, 2023 6:11 am
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 query supplied to the SQL Tuning Advisor.
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 query supplied to the SQL Tuning Advisor.