InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What is index cardinality in DB2? |
|
Answer» Index cardinality represents the number of DISCRETE VALUES or ENTRIES in a table column. DB2 has a utility called RUNSTATS which is used for examining column entry redundancy for finding whether an index SCAN is NEEDED to search the data. |
|