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 are column-name qualifiers used?
how to copy the host variables from ps file into cobol program other than include statement
what is db2 restart?
What are union and union all?
Update command
what happend with out using Commit,when closing cursor and program?
What is the latest version of ibm db2?
How can the duplicate values be eliminated from db2 select?
How to restart a DB2 program?
What is dbrm? What it contains? When it will be created?
How does db2 sample database connect?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.