DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

What is meant by index cardinality?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is meant by index cardinality?

The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to detemine whether to use a tablespace or index scan to search for data.

(Continued on next question...)

Other Job Interview Questions