Advertisement

SQL Access Advisor

  • Darl Kuhn
  • Sam R. Alapati
  • Bill Padfield

Abstract

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

Keywords

Enterprise 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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Darl Kuhn, Sam R. Alapati, and Bill Padfield 2012

Authors and Affiliations

  • Darl Kuhn
  • Sam R. Alapati
  • Bill Padfield

There are no affiliations available

Personalised recommendations