How many clustering indexes can be defined for a table?
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 |
What is bind plan?
Which components manage deadlocks in db2?
What is a correlated sub query?
What is catalog database in db2?
how can u nderstand the sql stmts executed successfully or not ?
How to create db2 table in mainframe?
How would you find out the total number of rows in a db2 table?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What is the difference between primary key & unique index ?
Explain about mirror activator disk mirroring?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?