Sample Header Ad - 728x90

DB2 Cardinality

-1 votes
1 answer
198 views
In my tables, I have many **statistics** with -1 and I want to know how can I enforce DB2 to calculate these values.
Select FIRSTKEYCARD, FIRST2KEYCARD, FIRST3KEYCARD, FIRST4KEYCARD, FULLKEYCARD
    FROM SYSCAT.INDEXES
    WHERE (TABSCHEMA = SCHEMA_NAME) AND
          (TABNAME   = TABLE_NAME)
My collection statistics look like Automatic maintenance (AUTO_MAINT) = OFF Automatic database backup (AUTO_DB_BACKUP) = OFF Automatic table maintenance (AUTO_TBL_MAINT) = OFF Automatic runstats (AUTO_RUNSTATS) = OFF Real-time statistics (AUTO_STMT_STATS) = OFF Statistical views (AUTO_STATS_VIEWS) = OFF Automatic sampling (AUTO_SAMPLING) = OFF Automatic column group statistics (AUTO_CG_STATS) = OFF Automatic reorganization (AUTO_REORG) = OFF
Asked by DB2fan (1 rep)
Jan 19, 2023, 01:24 PM
Last activity: Jan 20, 2023, 02:37 PM