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: AdministratorA.Equijion predicates
Submitted by: Administrator
Submitted by: Administrator
Read Online IBM Certification Job Interview Questions And Answers
Top IBM Certification Questions
☺ | Explain With database logging, where are transaction records first placed? |
☺ | Explain Which of the following DB2 data types CANNOT be used to contain the date an employee was hired? |
☺ | When Disk space for a table is allocated in one or more units called what? |
Top Certifications Categories
☺ | CCIE Certification Interview Questions. |
☺ | CCSP Certification Interview Questions. |
☺ | AFMC Interview Questions. |
☺ | Sun Certification Interview Questions. |
☺ | CCDA Certification Interview Questions. |