Syntax options:

    CARDINALITY COLLECTION IS ENABLED | CARDINALITY COLLECTION IS
    DISABLED

    Specifies whether or not the optimizer records cardinality
    updates in the system tables. When enabled, the optimizer
    collects cardinalities for tables and indexes as rows are
    inserted or deleted from tables. The update of the cardinalities
    is performed at commit time, if sufficient changes have
    accumulated, or at disconnect time.

    In high update environments, it may be more convenient to
    disable cardinality updates. If you disable this feature, you
    should manually maintain the cardinalities using the RMU Collect
    Optimizer_Statistics command so that the optimizer is given the
    most accurate values for estimation purposes.

    Cardinality collection is enabled by default.