Answer Posted / 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 |
Post New Answer View All Answers
How many databases can be created inside an instance in db2 ?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What os does db2 run on?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is collection in db2 bind?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How is a typical db2 batch pgm executed?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How to check sequence on a table in db2?
What is db2 bind?
If I have a view which is a join of two or more tables, can this view be updateable?
How can you quickly find out the # of rows updated after an update statement?
What does sqlcabc has?
What is the role of union all and union
What is netezza database?
