solidDB Help : solidDB reference : solidDB ADMIN COMMAND syntax : FIXCARDINALITY
  
FIXCARDINALITY
ADMIN COMMAND 'fixcardinality [catalog] [schema] [table]'
Abbreviation: fixcar
Calculates and fixes cardinality of a table.
Certain operations in solidDB can lead to the row count/cardinal value in the solidDB system table for some tables to be incorrect, which might result in some queries choosing a less effective query plan.
Either include the table name (with or without catalog or schema name) to fix the specified table, or run the command with no options to check the cardinal values for every table.
Go up to
solidDB ADMIN COMMAND syntax