Interested to Buy Any Domain ? << Click Here >> for more details...
How many clustering indexes can be defined for a table?
- 2 Answers
- 7080 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
How do I add a column to an existing table in db2?
What is a system catalog table in db2?
What is a buffer in memory?
Update command
When the like statement is used?
Explain package in db2 and its advantages?
How can we define a table? How can we apply SEARCH ALL on it ?
what are the bind parameters?
Is db2 free?
What is bind package and plan in db2?
How do I delete a table in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
COBOL 
