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 db2? Explain.
What is the STOSPACE Utility used for?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
What is cursor with hold option in db2?
Suppose if I need to update a column, how you do that using cursor?
What is explain in db2?
What is an access path?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
What is difference between *omit and *nopass?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What are packages in db2?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?