Glossary

COLGROUP

Collects multi-column cardinality statistics. If the optimizer sees a predicate on ACCT_TYPE AND POSTING_DATE, it needs to know the combined cardinality, not just the individual column cardinalities multiplied together (which overestimates selectivity when columns are correlated). - **FREQVAL COUNT

Learn More

Related Terms