How does DB2 use multiple table indexes?

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


Please Help Members By Posting Answers For Below Questions

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 .....

2136


Define predicate?

897


Can there be more than one cursor open for any program?

928


What's The Error Code For Unique Index Voilation?

910


What is the usage of open cursor command?

810


What is commit in db2?

826


What is runstats and reorg in db2?

1036


Explain about rct in db2?

881


Are views updateable?

850


what is diffrence b/w file-aid tool and file-aid utility???

4550


What is dbrm? What it contains?

926


What is dbrm in db2 database?

809


What is a system catalog table in db2?

865


What is the maximum No of rows per page?

842


What are the bind parameters ibm db2?

827