var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: db2set hash_join
What is the significance of setting HASH_JOIN using
When do we really require it.
This allows DB2 to choose a hash join method if it thinks it is the best access path. Hash Joins are explained in the "Administration Guide: Performance."
The default for version 7 is NO and the default for version 8 is YES. I would use the default depending on your DB2 version number, unless you determine that it is causing a performance problem.
Re: db2set hash_join
Visit the new-look IDUG Website
, register to gain access to the excellent content.