SQL$HELP72.HLB  —  CREATE  INDEX  Arguments  MINIMUM_RUN_LENGTH
    Specifies the minimum length of the sequence that Oracle Rdb
    should compress. You cannot alter this value once you set it.

    If you specify MINIMUM RUN LENGTH 2, Oracle Rdb compresses
    sequences of two or more spaces or of two or more binary zeros
    for single-octet character sets, and compresses one space or
    one binary zero for multi-octet character sets. As it compresses
    the sequences, Oracle Rdb replaces the sequence with the value
    of the minimum run length plus 1 byte. If many of the index
    values contain one space between characters in addition to
    trailing spaces, use a minimum run length of 2, so that you do
    not inadvertently expand the index beyond the 255-byte limit. If
    you inadvertently expand the index beyond 255 bytes during index
    creation, Oracle Rdb returns a warning message.

    The default minimum run length value is 2. Valid values for the
    minimum run length range from 1 to 127. Oracle Rdb determines
    which characters are compressed.
Close Help