How does Db2 use multiple table indexes?

DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.
  • Interview Candidate
  • 3
  • 3453

Showing Answers 1 - 3 of 3 Answers

Sandhya.Kishan

  • Jul 9th, 2012
 

By using the concept of list prefetch DB2 uses multiple index processing.I is used to satisfy multiple predicates in a select statement that are joined by an AND or OR.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions