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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.