SQL$HELP72.HLB  —  ALTER  INDEX  Arguments  PREFIX_CARDINALITY_COLLECTION_IS_ENABLED_FULL
    This setting requests that extra I/O be performed, if required,
    to ensure that the cardinality values reflect the key value
    changes of adjacent index nodes. If this clause is used on an
    index which is currently set to PREFIX CARDINALITY COLLECTION
    DISABLED or ENABLED, the RMU Collect Optimizer_Statistics command
    needs to be executed as soon as possible to load the correct
    values.
Close Help