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

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 query supplied to the
SQL Tuning Advisor.

Show Hint

Leave a Reply 1

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

kamruzzaman

kamruzzaman

The SQL Tuning Advisor provides options to manage the scope and duration of a tuning task. The scope of a tuning task can be set to limited or comprehensive.

If the limited option is chosen, the SQL Tuning Advisor produces recommendations based on statistics checks, access path analysis, and SQL structure analysis. SQL Profile recommendations are not generated.

If the comprehensive option is selected, the SQL Tuning Advisor carries out all the analysis it performs under limited scope plus SQL Profiling. With the comprehensive option you can also specify a time limit for the tuning task, which by default is 30 minutes.

Reply