Interested to Buy Any Domain ? << Click Here >> for more details...
How many clustering indexes can be defined for a table?
- 2 Answers
- 7079 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 the role of schema in the db2 database?
How to find primary key of a table in db2?
Which isolation level provides maximum concurrency?
List down the types of triggers in the db2 database?
How can record locking be achieved in those DB2 versions which do not support it?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is access path in db2?
How do I optimize a query in db2?
What is the difference between plan and package in db2?
What is copy pending and check pending in db2?
What is the use of runstats in db2?
What is the latest version of ibm db2?
What is a cursor in programming?
Explain various types of locks in db2?
What is the difference between bind and rebind in db2?
