Advertisement

B-tree Indexes

  • Darl Kuhn
  • Sam R. Alapati
  • Bill Padfield

Abstract

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 associated via primary and foreign key constraints.

Keywords

Query Optimizer Unique Index Index Block Parent Table Bitmap Index 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

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

Authors and Affiliations

  • Darl Kuhn
  • Sam R. Alapati
  • Bill Padfield

There are no affiliations available

Personalised recommendations