Which three functions can be performed by the SQL Tunin…

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

A.
recommending creation of indexes based on SQL workload

B.
recommending restructuring of SQL statements that have suboptimal plans

C.
checking schema objects for missing and state statistics

D.
recommending optimization of materialized views

E.
generating SQL profiles



Leave a Reply 8

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


Richard

Richard

The correct answers should be B, C, and E.

– B is incorrect because the Automatic Tuning Optimizer does not analyze how its index recommendation can affect the entire SQL workload. SQL Access Advisor examines the effect of creating an index on the SQL workload before making recommendations.

– Recommending optimization of materialized views is indeed one of the features of SQL Access Advisor.

Richard

Richard

I meant to say A is incorrect.