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
Last activity: Jan 20, 2023, 02:37 PM