OCP 1Z0 053 39

39.View the Exhibit to examine the Automatic SQL Tuning result details. Which action would you suggest 
for the selected SQL statement in the Exhibit? 

A. Accept the recommended SQL profile. 
B. Collect statistics for the related objects. 
C. Run the Access Advisor for the SQL statement. 
D. Run the Segment Advisor for recommendations. 

Answer: C 

recommendations 建议创建索引。

需要通过Access Advisor来确认创建什么索引

http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF008

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.

......