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
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Darl Kuhn, Sam R. Alapati, and Bill Padfield
About this chapter
Cite this chapter
Kuhn, D., Alapati, S.R., Padfield, B. (2012). SQL Access Advisor. In: Expert Indexing in Oracle Database 11g. Apress. https://doi.org/10.1007/978-1-4302-3736-5_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3736-5_10
Publisher Name: Apress
Print ISBN: 978-1-4302-3735-8
Online ISBN: 978-1-4302-3736-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books