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 |
The only place of VSAM KSDS in DB2 is?
What is deadlock?
How to connect to db2 database from windows command line?
Name some fields from SQLCA.
What are some SQL aggregates and other built-in functions?
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. TIA
How to create a table using embedded sql?
What is the size of a data page?
Is db2 a mainframe database?
What are the various isolation levels possible?
Which one allows duplicate values Union or Union All ?
What is ibm db2 client?