How many clustering indexes can be defined for a table?
Answer Posted / mehdee
Yes Only one clustering index can be defined.And reason is
Clustered indexe is created to order the rows in the
DB2 table in the same physical order as the desired result
from the indexe. And if we do not use this option, DB2 will
come up with one to do this ordering rows.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do I change the column size in db2?
How to restart a DB2 program?
What is difference between alias and synonym in db2?
How to create backup table in db2?
Explain about open switch business continuity software?
How to connect to db2 database from windows command line?
What is db2 bind?
How do I start db2 in windows?
What is dbrm? What it contains? When it will be created?
What is isolation level in db2?
What is a bind card?
define clustering index.
What is dclgen in db2?
What is host variable in db2 cobol?
What is the latest version of ibm db2?