Interested to Buy Any Domain ? << Click Here >> for more details...
What is index cardinality?
- 3 Answers
- 11007 Views
- I also Faced
- E-Mail Answers
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 |
what happend with out using Commit,when closing cursor and program?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is the picture clause of the null indicator variable?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What is temporal table in db2?
What is the difference between db2 and oracle?
Explain various types of locks in db2?
What is reorg in DB2
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
What is COPY PENDING status?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
COBOL 
