Interested to Buy Any Domain ? << Click Here >> for more details...
What is index cardinality?
- 3 Answers
- 11029 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 |
How to connect to db2 database from windows command line?
What is a correlated sub query?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
How can you quickly find out the # of rows updated after an update statement?
What is Skeleton cursor table (SKCT)?
Mention the definition of cobol in varchar field.
What types of tables are there in the db2 database?
What does db2 mean?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
How to find the number of rows in db2 tables?
What is a collection?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
COBOL 
