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.