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.
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
© 2011 Sam R. Alapati, Darl Kuhn, and Bill Padfield
About this chapter
Cite this chapter
Alapati, S.R., Kuhn, D., Padfield, B. (2011). Choosing and Optimizing Indexes. In: Oracle Database 11g Performance Tuning Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3663-4_2
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3663-4_2
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3662-7
Online ISBN: 978-1-4302-3663-4
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books