Creates an index for a table. An index allows direct access to
the rows in the table to avoid sequential searching.
You define an index by listing the columns in a table that make
up the index. You can define more than one index for a table. The
index can be made up of one column, or two or more columns. An
index made up of two or more columns is called a multisegmented
index.
Optional arguments to the CREATE INDEX statement let you specify:
o The type of index structure (hashed, sorted nonranked, or
sorted ranked)
o The names of a storage area or storage areas that contain the
index
o Physical characteristics of a sorted index structure, such as
index node size and the initial fullness percentage of each
node
o Compression characteristics, including compressed key suffixes
for text indexes and integer column compression for smallint
or integer numeric columns
o Compression of space characters from text data types and of
binary zeros from nontext data types
o Thresholds for the logical storage areas that contain the
index
o A comment for the index definition
o Whether logging to the .ruj and .aij files is enabled or
disabled for the create index operation
Additional Information:
explode
extract