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
How to run db2 command in windows?
Is it possible using max on a char column?
Why do we need reorg in db2?
What is null value in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is universal database?
What parameters are used to control the free space in DB2?
What is the advantage in De-normalizing tables in DB2?
What is ibm db2 connect?
What is a db2 schema?
What does a deadlock mean in DB2?
Is db2 free?
How can you find out the # of rows updated after an update statement?
How can record locking be achieved in those DB2 versions which do not support it?
What is a db2 package?
