IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
Share 'RUNSTATS sampling enhancements'
Introduction:One of the major challenges for RUNSTATS is the sampling of the data rows e.g. for calculation of the COLCARD value in SYSIBM.SYSCOLSTATS and SYSIBM.SYSCOLUMNS.
The challenge is to balance the CPU resources used by RUNSTATS to calculate column cardinalities with high accuracy versus the likelihood that optimizer selects a bad access path due to the possibly inaccurate statistics valu…
You can share this blog post in two ways…
Share this link:
Send it with your computer's email program: Email this