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
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What db2 400?
What is explain in db2?
What is dbrm? What it contains?
What are db2 objects?
What is the connection string to connect to the DB2 Database ?
What r the comman abends in db2, jcl and cobol???????
What is page size in db2?
Where can you declare a cursor in a cobol-db2 program?
What is scrollable cursor in db2?
How can you classify the locks in db2?
What is drop table?
When reorg is used?
Before you give the explain statement, what are the prerogatives?
How do you pull up a query which was previously saved in qmf?
