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
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the difference between oracle and db2?
What is a system catalog table in db2?
What is db2 purescale?
What is db2 catalog database?
Explain correlated sub-queries.
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the syntax for FETCH in DB2 ?
What is phantom read in db2?
What is a db2 table?
What is meant by union and union all?
What are packages in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Explain about cursor stability?
