Interested to Buy Any Domain ? << Click Here >> for more details...
What is index cardinality?
- 3 Answers
- 11156 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 is the difference between dbm cfg and db cfg file in db2 ?
what happend with out using Commit,when closing cursor and program?
What are the various locks available?
How to create a table using embedded sql?
How do I delete a table in database?
what are the SQL codes u freequently got?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What is iseries database?
What's the maximum number of characters that a tablename can have?
How is the SUBSTR keyword used in sql?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
How do you insert a record with a nullable column?
COBOL 
