11.3.1 Defining indexes

To define an index (B-tree index, text index, or range index) for a base table, execute the CREATE INDEX statement. For details about the CREATE INDEX statement, see CREATE INDEX (define an index) in Definition SQL Statements in the manual HADB SQL Reference.

You can define indexes only for base tables that you (the HADB user with the authorization identifier currently connected to the HADB server) own. A user cannot define indexes for a base table that is owned by another HADB user.

Text indexes cannot be defined for column store tables.

See the following sections to define indexes for appropriate columns:

• 5.3 Designing a B-tree index

• 5.4 Designing a text index

• 5.5 Designing a range index

Important

When you define an index for a table for which segments for storing rows are allocated, the index is placed in unfinished status (and no index data is created). Indexes in unfinished status cannot be used to retrieve, add, update, or delete data.

For details about how to release an index from unfinished status, see the following subsections:

• 15.9.1 Steps to take when unfinished status is applied to a B-tree index

• 15.10.1 Steps to take when unfinished status is applied to a text index

• 15.11.1 Steps to take when unfinished status is applied to a range index

For details about the status of allocating segments for storing rows, see 5.3.1 Notes on defining B-tree indexes (unfinished status of B-tree indexes).

To Page Top