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
Is db2 a mainframe database?
What does a deadlock mean in DB2?
Mention some fields that are a part of sqlca.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is iseries database?
How do I add a column to an existing table in db2?
What does db2 stand for?
What is dbrm? What it contains? When it will be created?
How to execute stored procedures?
How to find primary key of a table in db2?
How does coalesce work?
How many types of page locks can be held in db2?
What is explain in db2?
What is the max length of sqlca?
What is host variable?
