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 ...