Interested to Buy Any Domain ? << Click Here >> for more details...
How many clustering indexes can be defined for a table?
- 2 Answers
- 7100 Views
- I also Faced
- E-Mail Answers
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
What is dbrm? When it will be created?
How to check last update on table in db2?
How can you classify the locks in db2?
Discuss about db2 bind?
What is the information associated with sysibm.syslinks table?
Mention the various locks that are available in db2.
How to rename a table in DB2 ?
What is the physical storage length of date data type?
Is ibm db2 open source?
How do I import data from excel to db2?
What is a cursor in programming?
What is node in db2?
How do I import a csv file into db2?
How do I optimize a query in db2?
How is deadlock resolved?
