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.