Interested to Buy Any Domain ? << Click Here >> for more details...
What is index cardinality?
- 3 Answers
- 11038 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 |
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
How to execute stored procedures?
How would you find out the total number of rows in a db2 table?
How do you check for a null value in a db2 column?
What is runstats db2?
How will you return the number of records in table?
What is COPY PENDING status?
How to resolve -502 sql code in DB2?
How can you find out the # of rows updated after an update statement?
What is the use of runstats in db2?
how to identify the pseudo conversation by seeing the program
How can deadlocks be resolved?
COBOL 
