Abstract
An index is a database object used primarily to improve the performance of SQL queries. The function of a database index is similar to an index in the back of a book. A book index associates a topic with a page number. When you’re locating information in a book, it’s usually much faster to inspect the index first, find the topic of interest, and identify associated page numbers. With this information, you can navigate directly to specific page numbers in the book. In this situation, the number of pages you need to inspect is minimal.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2013 Sam R. Alapati
About this chapter
Cite this chapter
Alapati, S.R., Kuhn, D., Padfield, B. (2013). Choosing and Optimizing Indexes. In: Oracle Database 12c Performance Tuning Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6188-9_2
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6188-9_2
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6187-2
Online ISBN: 978-1-4302-6188-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books