Updatable Catalog Statistics in Db2 12
(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 blogs@bmc.com. Db2 is a registered trademark of the IBM Corporation.