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
Explain what are the various isolation levels possible?
What is rct?
What is a buffer in memory?
What is plan in cobol db2?
Explain in brief how does db2 determine what lock-size to use?
What is package in db2 mainframe?
What is the function of logging in the db2 database?
What are types of indexes?
Is the primary key a clustered index?
What is an instance database?
What is db2? Explain.
What is universal database?
Explain about open switch business continuity software?
What is node in db2?
Define buffer pool.
