VMS Help  —  RMU72  Show  Optimizer Statistics, Command Qualifiers, Full
    Full
    Nofull

    This qualifier can only be used if table, index, or index prefix
    cardinality statistics are being displayed. If this qualifier is
    specified, the following cardinality information is displayed:

    o  Actual cardinality

       Displays the current table, index, or index prefix cardinality
       value.

    o  Stored cardinality

       Displays the table, index, or index prefix cardinality value
       stored in the system relations.

    o  Difference between the stored and actual cardinality values

       This value is negative if the stored cardinality is less than
       the actual cardinality.

    o  Percentage cardinality difference from the actual value

       This value is calculated by dividing the difference between
       the stored and actual cardinality values by the actual
       cardinality value. It is negative if the stored cardinality
       is less than the actual cardinality.

    The default value is Nofull.
Close Help