What is index cardinality?
Answers were Sorted based on User's Feedback
Answer / dave ian
the number of UNIQUE values for a column or columns, which
are part of an index.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / s
Cardinality is the number of distinct values for a given
column or group of columns.
FIRSTKEYCARDF contains the cardinality of the leading
column in the index
FULLKEYCARDF contains the cardinality of all the columns in
the index
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / uday
According to what i have observed, cardinality is the number
of count of nodes in the BTree of respective index.
If you create a table with with name attribute and inserted
into 100 new names and added and index.
then if you see the cardinality, certainly it wont be 100.
it will be some thing less than 100.
thats it....
Is This Answer Correct ? | 0 Yes | 1 No |
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is COPY PENDING status?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Which transaction use a command thread ?
How to insert more than one record using insert?
What does reorg do in db2?
How do you retrieve the data from a nullable column?
What is dbrm in db2 database?
What is the difference between db2 and oracle?
What is the difference between Where and Having Clause
What is sqlca?
What os does db2 run on?