SQL$HELP72.HLB  —  CREATE  INDEX  Arguments  ENABLE_COMPRESSION
    Specifies that sorted and hashed indexes are stored in a
    compressed form.

    If compression is enabled, Oracle Rdb uses run-length compression
    to compress a sequence of space characters (octets) from text
    data types and binary zeros from nontext data types. Different
    character sets have different representations of the space
    character. Oracle Rdb compresses the representation of the space
    character for the character sets of the columns comprising the
    index values.

    You cannot disable index compression using the ALTER INDEX
    statement once you specified the ENABLE COMPRESSION clause of
    the CREATE INDEX statement.

    For more information on compressed indexes, see the Oracle Rdb
    Guide to Database Design and Definition.
Close Help