Join ExamsbookAnswer :
What is meant by index cardinality?5
Q: What is meant by index cardinality?
- Show Answer
- Workspace
Answer :
Explanation :
The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data.