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 |
How do you pull up a query which was previously saved in qmf?
What is normalization and what are the five normal forms?
When do you use the IMAGECOPY?
What is iseries database?
What is a cursor and what is its function?
What information is held in SYSIBM.SYSCOPY?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What language is db2 written in?
What is Declaration Generator(DCLGEN)?
Who uses db2?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM