Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is meant by dclgen?
What are the full forms of spufi and dclgen and why are they used?
How do I copy a table in db2?
Which component is used to execute the sql statements?
What is the difference between spufi and qmf?
What is the maximum size of a char data type in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is the role of schema in the db2 database?
What is bind package and plan in db2?
What is bufferpool in db2?
How do I start db2 in windows?
What is collection in db2 bind?
What is the use of db2?
What are the benefits of using the db2 database?
How to find schema of a table in db2?
