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 are union and union all?
What are the rules for db2 programming?
What is null indicator in db2?
What is an instance database?
How and when does the db2 enforces the unique key?
What is the use of predicate?
What is bind plan?
What is runstats db2?
How many databases can be created inside an instance in db2 ?
How to test SQL -911 error while developing COB-DB2 program
Explain package in db2 and its advantages?
What are the two types of logging in the db2 database? Explain them.
Can one database have multiple instances?
What is isolation level in db2?
What is dclgen (declaration generator)?
