CHAPTER 10
SQL Access Advisor
Oracle's SQL Access Advisor is a flexible tuning tool that analyzes either a single SQL statement or a group of SQL statements and generates advice on how to improve performance by recommending the creation of the following types of objects:
- Indexes
- Materialized views
- Materialized view logs
- Partitions for tables, indexes, and materialized views
SQL Access Advisor provides advice on implementing B-tree, bitmap, and function-based indexes. The tool provides specific SQL index creation statements as part of its output. Also provided are recommendations on optimizing materialized views through fast refreshes and query ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
