What is a clustering index?
Answers were Sorted based on User's Feedback
Answer / pawan
Clustered indexes can be created to order the rows in the
table in the same physical order as the desired result
set.Clustered indexes allow for a more linear access
pattern to data pages and more effective prefetching, and
help avoid sorts.Only one cluster index can be created on
table.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / s
Clustering Index is an index defined with the CLUSTER
keyword and determines where the row should be inserted to
maintain the clustering sequene
Is This Answer Correct ? | 1 Yes | 0 No |
What is explain plan in db2?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What does DSNDB07 database do?
What are the four lockable units for DB2?
What kind of database is db2?
What is DCLGEN ?
Can one database have multiple instances?
I use CS and update a page. Will the lock be released after I am done with that page?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
what is + sign and -ve sign for sql code ?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1