DB2 uses multiple index processing by using the technique called list pre

How does DB2 use multiple table indexes?

Question Posted / s

1 Answers
5813 Views
I also Faced
E-Mail Answers

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

What is collection in db2 bind?

1017

How do I connect my db2 database to ibm?

1051

How can record locking be achieved in those DB2 versions which do not support it?

1076

what is db2 restart?

2162

What type of database is db2?

971

What does db2 mean?

1017

Is db2 a programming language?

1048

What happens in bind step in a db2 program?

974

Explain about rct in db2?

1109

What is the use of commit in db2?

1083

What is dpf in db2?

1109

What do you mean by storage group (stogroup)?

1041

What is db2 look?

1024

What is the use of db2 optimizer?

1117

What is a db2 table?

1017