Your database supports a DSS workload that involves the execution of complex queries:
Currently, the library cache contains the ideal workload for analysis. You want to analyze
some of the queries for an application that are cached in the library cache. What must you
do to receive recommendations about the efficient use of indexes and materialized views to
improve query performance?
A.
Create an STS that contains the queries cached in the library cache and run the SQL
Performance Analyzer (SPA) on the workload captured in the STS.
B.
Create an STS that contains the queries cached in the library cache and run the SQL
Access Advisor on the workload captured in the STS.
C.
Run the Automatic Workload Repository Monitor (ADDM).
D.
Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and
run the SQL Tuning Advisor (STA) on the workload captured in the STS.
Answer is B, Created an SITS which have queries cached in the library cache and run SAA on workload captured in the STS
B
SQL Access Advisor helps you achieve your performance goals by recommending the proper set of materialized views, materialized view logs, partitions, and indexes for a given workload. Materialized views, partitions, and indexes are essential when tuning a database to achieve optimum performance for complex, data-intensive queries.
SQL Access Advisor takes an actual workload as input, or derives a hypothetical workload from a schema. The advisor then recommends access structures for faster execution path.