(This article is part of our Db2 Guide. Use the right-hand menu to navigate.)
Catalog statistics that updatable and used for access path selection
Table | Statistics |
SYSIBM.SYSCOLDIST | CARDF COLGROUPCOLNO COLVALUE FREQUENCYF HIGHVALUE LOWVALUE NUMCOLUMNS QUANTILENO TYPE |
SYSIBM.SYSCOLSTATS | COLCARD HIGHKEY LOWKEY PARTITION |
SYSIBM.SYSCOLUMNS | COLCARDF HIGH2KEY LOW2KEY |
SYSIBM.SYSINDEXES | CLUSTERRATIOF FIRSTKEYCARDF FULLKEYCARDF NLEAF NLEVELS DATAREPEATFACTORF |
SYSIBM.SYSINDEXSTATS | DATAREPEATFACTORF |
SYSIBM.SYSKEYTARGETS | HIGH2KEY LOW2KEY STATS_FORMAT |
SYSIBM.SYSKEYTGTDIST | CARDF KEYGROUPKEYNO KEYVALUE FREQUENCYF HIGHVALUE LOWVALUE NUMKEYS QUANTILENO TYPE |
SYSIBM.SYSROUTINES | CARDINALITY INITIAL_INSTS INITIAL_IOS INSTS_PER_INVOC IOS_PER_INVOC |
SYSIBM.SYSTABLES | CARDF NPAGES NPAGESF PCTROWCOMP |
SYSIBM.SYSTABLESPACE | NACTIVEF |
SYSIBM.SYSTABSTATS | CARDF NPAGES |
Disclaimer: This Db2® 12 for z/OS Reference Guide was developed to help users in their daily activities in administrating and programming in Db2 for z/OS. There are no guarantees expressed or implied with the contents in this guide. We want to provide a quality and useful reference for users. Please notify us of any mistakes or errors in this reference guide at [email protected]. Db2 is a registered trademark of the IBM Corporation.