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

What do you mean by commit and rollback?

594


Explain about rct in db2?

640


Why cursor is used in db2?

575


Is db2 a mainframe?

588


How do you simulate the explain of an embedded sql statement in spufi/qmf?

635






Explain about dbrm.

609


Discuss about db2 bind?

671


What is database manager in db2?

551


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

624


What is buffer pool in the db2 database?

618


Differentiate between cs and rr isolation levels? Where do you specify them?

586


Which command is used to remove all rows from a table?

553


When reorg is used?

676


How do I delete a column in db2?

680


Where do you specify them?

681