Interested to Buy Any Domain ? << Click Here >> for more details...
How many clustering indexes can be defined for a table?
- 2 Answers
- 7106 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
How to test SQL -911 error while developing COB-DB2 program
What is iseries database?
what are bind concepts in db2 cobol?
What is copy pending and check pending in db2?
What is a db2 schema?
What is sqlca?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is multi row fetch in db2?
What is an instance database?
Mention the definition of cobol in varchar field.
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How to find primary key of a table in db2?
What is a cursor in programming?
What is the use of dclgen in db2?
On which levels locks can be applied?
