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 do you mean by commit and rollback?
What is consistency token in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is db2 bind?
How does db2 sample database connect?
What do you mean by rollback?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is concurrency?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is null indicator in db2?
What is precompiler in db2?
How can the duplicate values be eliminated from db2 select?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the physical storage length of time data type?
What is the max length of sqlca?
