The DBA can set the registry variable DB2_HASH_JOIN on or off because:
A. hash joins may require more resources to run.
B. hash joins are not used unless outer joins are requested.
C. If hash joins are enabled, no other join method can be used.
D. Hash joins are only needed when the tables are portioned using hash keys.
Submitted by: AdministratorA.Hash joins may require more resources to run.
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. |
☺ | GATE Exam Interview Questions. |