Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database

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

Darl Kuhn, Sam R Alapati and Bill Padfield, Expert Oracle Indexing and Access Paths, 10.1007/978-1-4842-1984-3_1

1. Introduction to Oracle Indexes

Darl Kuhn¹ , Sam R. Alapati² and Bill Padfield³

(1)Morrison, Colorado, USA

(2)Flower Mound, Texas, USA

(3)Aurora, Colorado, USA

Electronic supplementary material

The online version of this chapter (doi:10.​1007/​978-1-4842-1984-3_​1) contains supplementary material, which is available to authorized users.

An index is a combination of a value and an associated location that allows you to quickly locate an object. If you think about it for a couple of seconds, you probably often use index structures to navigate throughout the day, such as:

• Browsing a catalog ...