Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / s
DB2 uses multiple index processing by using the technique
called list prefetch. The qualifying RIDS from all the
indexes in placed in the RID Pool, sorted and duplicate
RIDS are eliminated based on the page number and List
prefetch I/O issued to read the data pages in DASD
sequence.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between drop table and delete table?
What is the latest version of ibm db2?
what is the responsibility of the construction superintendent
What are the benefits of using the db2 database?
How to fetch the last row from the table in SQL (db2)?
What is the physical storage length of the data types date, time, and timestamp?
What is the use of db2 optimizer?
What is copy pending status in db2?
What is meant by dclgen?
What is the use of db2?
How does db2 sample database connect?
What are packages in db2?
Explain about dbrm.
What is a dbrm in db2?
What is cursor stability in db2?
