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 programming language?
Comment whether the cursor is closed during commit or not.
What is a system catalog table in db2?
What is runstats utility in db2?
How do I delete a column in db2?
What are concurrency issues?
What is universal database?
Define buffer pool.
What is the physical storage length of timestamp data type?
Are views updateable?
Which command is used to remove all rows from a table?
What is load utility in db2?
How to fetch the last row from the table in SQL (db2)?
Define check constraint.
What is the use of value function?
