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 |
How to check table size in db2 sap?
Which isolation level provides maximum concurrency?
What is meant by index cardinality?
When do you specify the isolation level? How?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is node in db2?
What is the picture clause of the null indicator variable?
What is CHECK PENDING ?
What are the various locks available?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
Is there any advantage to denormalizing DB2 tables?