Answers

Question and Answer:

  Home  IBM Certification

⟩ 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

 163 views

More Questions for you: