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


Please Help Members By Posting Answers For Below Questions

Define data page.

832


How to find primary key of a table in db2?

823


What is image copy in db2?

765


Is db2 a database?

749


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1806


What is the role of the data page in the db2 database?

786


Why cursor is used in db2?

774


Who uses db2?

774


define clustering index.

808


What do you mean by commit and rollback?

779


What is declare cursor?

830


What is cascading rollback?

863


What are db2 objects?

837


What does db2 stand for?

778


What is lock escalation in db2?

780