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
Define data page.
How to find primary key of a table in db2?
What is image copy in db2?
Is db2 a database?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is the role of the data page in the db2 database?
Why cursor is used in db2?
Who uses db2?
define clustering index.
What do you mean by commit and rollback?
What is declare cursor?
What is cascading rollback?
What are db2 objects?
What does db2 stand for?
What is lock escalation in db2?