The SQL Access Advisor may recommend additional structures to improve the performance of SQL statements. You can select the type of structure recommended by the SQL Access Advisor.
Which two structures can you select? (Choose two)
A.
Indexes
B.
Partitions
C.
Synonyms
D.
Sequences
E.
Database links
F.
Materialized views
G.
Hash or index clusters
H.
Index-Organized Table
Explanation:
Materialized views and indexes are essential when tuning a database to achieve optimum performance for complex, data-intensive queries. The SQL Access Advisor helps you achieve your performance goals by recommending the proper set of materialized views, materialized view logs, and indexes for a given workload.
REF.: Oracle 10g Performance Tuning Guide 17-1