O'Reilly logo

Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database by Bill Padfield, Sam R Alapati, Darl Kuhn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© 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_2

2. B-tree Indexes

Darl Kuhn, Sam R. Alapati2 and Bill Padfield3

(1)Morrison, Colorado, USA

(2)Flower Mound, Texas, USA

(3)Aurora, Colorado, USA

The B-tree index is the default index type in Oracle. This index type is known as B-tree because the table row identifier (ROWID) and associated column values are stored within index blocks in a balanced tree-like structure. Oracle B-tree indexes are used for the following reasons:

  • Improving SQL statement performance

  • Enforcing uniqueness of primary key and unique key constraints

  • Reducing potential locking issues with parent and child table tables ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required