Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?
A.
Create new indexes.
B.
Modify existing indexes.
C.
Implement partitioning on a nonpartitioned table.
D.
Create materialized views.
E.
All of the above
Explanation:
18.1 Overview of SQL Access Advisor
Materialized views, partitions, and indexes are essential when tuning a database to achieve optimum
performance for complex, data-intensive queries. 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. Understanding and using these structures is essential when optimizing SQL as they can
result in significant performance improvements in data retrieval. The advantages, however, do not come
without a cost. Creation and maintenance of these objects can be time consuming, and space requirements
can be significant. In particular, partitioning of an unpartitioned base table is a complex operation that must be
planned carefully.