What should you do to achieve this?

Your database supports a mixed workload. In an application, multiple complex queries with functions and
expressions are executing. You want to analyze the queries that are currently cached in the library cache to
receive recommendations about the usage of indexes and materialized views.
What should you do to achieve this? (Choose the best answer.)

Your database supports a mixed workload. In an application, multiple complex queries with functions and
expressions are executing. You want to analyze the queries that are currently cached in the library cache to
receive recommendations about the usage of indexes and materialized views.
What should you do to achieve this? (Choose the best answer.)

A.
Create an STS for the queries cached in the library cache and submit it as an input to SQL Tuning Advisor.

B.
Create an STS for the queries cached in the library cache and submit it as an input to SQL Access Advisor.

C.
Capture the workload in an STS and submit to SQL Tuning Advisor for recommendations.

D.
Create an STS for the queries cached in the library cache and submit it as an input to SQL Performance
Analyzer.



Leave a Reply 0

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