What is index cardinality?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

My sql statement select avg(salary) from emp yields inaccurate results. Why?

639


How is the value function used?

600


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

626


What is null value in db2?

563


Explain about mirror activator disk mirroring?

560






Explain correlated sub-queries.

587


What is lock escalation in db2?

574


What is a plan and package in db2?

621


What is dbrm? When it will be created?

596


What is the purpose of rollback and commit?

593


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

744


Define check constraint.

642


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3116


What is a trigger in the db2 database?

592


What are the full forms of spufi and dclgen and why are they used?

654