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:
Materialized view logs
Partitions for tables, indexes, and materialized views
KeywordsEnterprise Manager Index Creation Access Advisor Bitmap Index Buffer Cache
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Unable to display preview. Download preview PDF.
© Darl Kuhn, Sam R. Alapati, and Bill Padfield 2012