IBM Certification Interview Questions and Answers

 

Explain Which of the following is required for the DB2 optimizer to consider a hash join strategy?

A. Equijion predicates
B. Optimization level 1 or above
C. Registry variable DB_ANTIJOIN=YES
D. SORTHEAP large enough to contain the tables being joined





A. Equijion predicates




B. Optimization level 1 or above




C. Registry variable DB_ANTIJOIN=YES




D. SORTHEAP large enough to contain the tables being joined






A.Equijion predicates

Posted by:Richards