STATS-OPTIONS—Update the COLCARD Column

The STATS-OPTIONS keyword updates the COLCARD column of SYSCOLUMNS.
cafrdb2
The STATS-OPTIONS keyword updates the COLCARD column of SYSCOLUMNS. You can update all columns, or only those columns that are used in an index.
When you specify STATS-OPTIONS, also specify UPDATE-CATSTATS. Otherwise, the COLCARD value is not updated regardless of the STATS-OPTIONS value.
This keyword has the following format:
STATS-OPTIONS [
COLCARD-ALL
|COLCARD-INDEXED]
  • COLCARD-ALL
    Updates COLCARD for all columns, regardless of whether they are used in indexes. This value is the default.
  • COLCARD-INDEXED
    Updates COLCARD for only those columns that are used in indexes.