SQL$HELP72.HLB  —  CREATE  INDEX
    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
Environment Format Arguments Examples
Close Help