Interested to Buy Any Domain ? << Click Here >> for more details...
How many clustering indexes can be defined for a table?
- 2 Answers
- 6966 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
Which component is used to execute the sql statements?
What type of database is db2?
What is buffer pool in the db2 database?
What is a buffer in memory?
How would you find out the total number of rows in a db2 table?
What are the rules for db2 programming?
How to restart a DB2 program?
How do I delete a table in db2?
What is db2 command?
What is cascading rollback?
What is access path in db2?
What is the maximum number of columns in a db2 table?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
what is the sqlcode -501
What is the use of predicate?
