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 3

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


vasya

vasya

suppose SQL Access Advisor looks better over here, answer B