Implementing B-tree Indexes

This section describes typical tasks you'll encounter when working with B-tree indexes. Typical tasks include:

  • Creating indexes.
  • Reporting on indexes.
  • Displaying code required to re-create an index.
  • Dropping indexes.

These tasks are detailed in the following subsections.

Creating a B-tree Index

Listed next is a sample script that creates a table and its associated indexes in separate tablespaces. The tables and indexes inherit their storage attributes from the tablespace; this is because no storage parameters are specified in either the CREATE TABLE or CREATE INDEX statements.

Also, you want the primary key and unique key constraints to automatically create B-tree indexes (for more details on this topic, see the ...

Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.