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
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Define predicate?
Can there be more than one cursor open for any program?
What's The Error Code For Unique Index Voilation?
What is the usage of open cursor command?
What is commit in db2?
What is runstats and reorg in db2?
Explain about rct in db2?
Are views updateable?
what is diffrence b/w file-aid tool and file-aid utility???
What is dbrm? What it contains?
What is dbrm in db2 database?
What is a system catalog table in db2?
What is the maximum No of rows per page?
What are the bind parameters ibm db2?