Glossary

Table cardinality and page count

via basic RUNSTATS (always collect this) 2. **COLCARD for all indexed columns** — essential for filter factor calculation 3. **Frequency values for skewed columns** — STATUS, TYPE, STATE, and similar categorical columns 4. **HIGH2KEY/LOW2KEY for range-queried columns** — DATE, AMOUNT, BALANCE column

Learn More

Related Terms