2.3.21 CREATE INDEX

Table of Contents Previous Next


2 The SQL Language : 2.3 SQL Commands : 2.3.21 CREATE INDEX

CREATE INDEX -- define a new index
( { column | ( expression ) } )
[ TABLESPACE tablespace ]
CREATE INDEX constructs an index, name, on the specified table. Indexes are primarily used to enhance database performance (though inappropriate use will result in slower performance).
Note: An index cannot be created on a partitioned table.
Advanced Server provides the B-tree index method. The B-tree index method is an implementation of Lehman-Yao high-concurrency B-trees.
Indexes are not used for IS NULL clauses by default.
The tablespace in which to create the index. If not specified, default_tablespace is used, or the database’s default tablespace if default_tablespace is an empty string.

2 The SQL Language : 2.3 SQL Commands : 2.3.21 CREATE INDEX

Table of Contents Previous Next