Which identifies and helps to resolve performance problems relating to the execution of SQL statements by recommending which indexes…

The ______ identifies and helps to resolve performance problems relating to the execution of SQL statements by recommending which indexes, materialized views, or materialized view logs to create, drop, or retain.

The ______ identifies and helps to resolve performance problems relating to the execution of SQL statements by recommending which indexes, materialized views, or materialized view logs to create, drop, or retain.

A.
Undo Advisor

B.
MTTR Advisor

C.
Memory Advisor

D.
Segment Advisor

E.
SQL Tuning Advisor

F.
SQL Access Advisor

Explanation:
The SQL Access Advisor helps you achieve your performance goals by recommending the proper set ofmaterialized views, naterialized view logs, and indexes for a given workload . The SQL Access Advisor recommends bitmap, function-based, and B-tree indexes. A bitmap index offers a reduced response time for many types of ad hoc queries and reduced storage requirements compared to other indexing techniques. B-tree indexes are most commonly used in a data warehouse to index unique or near-unique keys. Another component of the SQL Access Advisor also recommends how to optimize materialized views so that they can be fast refreshable and take advantage of general query rewrite.

REF.: Oracle Performance Guide – SQL Access Advisor 17-1



Leave a Reply 0

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