Interested to Buy Any Domain ? << Click Here >> for more details...
What is a clustering index?
- 2 Answers
- 5448 Views
- I also Faced
- E-Mail Answers
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 |
Can we update view in db2?
Is db2 free?
is there any restrictions for unions ?
Mention the definition of cobol in varchar field.
Why do we bind in db2?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is db2 and what is the use of db2 optimizer?
How to find the number of rows in db2 tables?
Explain packages.
how to copy the host variables from ps file into cobol program other than include statement
Define check constraint.
What is the use of commit in db2?
COBOL 
