3.3.19 CREATE INDEX

Table of Contents Previous Next


3 The SQL Language : 3.3 SQL Commands : 3.3.19 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).
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.
If you create an index on a partitioned table, the CREATE INDEX command does not propagate indexes to the table's subpartitions.
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.

3 The SQL Language : 3.3 SQL Commands : 3.3.19 CREATE INDEX

Table of Contents Previous Next