IBM Certification Question: Download Questions PDF
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
Answer:
A.Equijion predicates
Download IBM Certification Interview Questions And Answers
PDF