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

Submitted by: Administrator
A.Equijion predicates
Submitted by: Administrator

Read Online IBM Certification Job Interview Questions And Answers