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.