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.

View Answer
Option – A.

More Questions

error: Content is protected !!