Oracle 11g SQL Access Advisor Enhancements(原创)

Overview SQL Access Advisor
Oracle introduced the SQL Access Advisor in the Oracle database 10g Release to help you create efficient access structures to optimize SQL queries. The advisor accepted either an actual workload as input (from the cursor cache or an STS from the automatic workload repository) or used a hypothetical workload created by you to recommend which indexes, materialized views, or materialized view logs to create and drop to improve SQL performance. In Oracle Database 11g, there are several enhancements to the SQL Access Advisor:  Oracle introduced the S