Syntax options:

       CARDINALITY COLLECTION IS ENABLED
       CARDINALITY COLLECTION IS DISABLED

 Specifies whether or not the optimizer records cardinality
 updates in the system table. When enabled, the optimizer collects
 cardinalities for the table and non-unique 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 Analyze
    Cardinality command so the optimizer is given the most accurate
    values for estimation purposes.

    Cardinality collection is enabled by default.