Interested to Buy Any Domain ? << Click Here >> for more details...
What is index cardinality?
- 3 Answers
- 10866 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 responsibility of the construction superintendent
What are PACKAGES ?
what is static sql? what is dynamic sql? Give me details
Where is the access path logic created by the DB2 Optimizer stored?
How to resolve -502 sql code in DB2?
What is a DB2 bind?
What is ALTER ?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
How to define the data items to receive the fetch items for the SQL?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the maximum size of a char data type in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
COBOL 
