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
How do I import a csv file into db2?
What is reorg and runstats in db2?
What is the syntax for FETCH in DB2 ?
What are packages in db2?
What is sqlca?
What is image copy in db2?
What is the reason behind not using select * in embedded sql programs?
How and when does the db2 enforces the unique key?
What is db2 catalog database?
What os does db2 run on?
What are the bind parameters ibm db2?
What are types of indexes?
What is concurrency?
What is a collection in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
