(Dwaine Snow) In previous version of DB2, the DB2 optimizer would normally choose between two different join methods: a nested loop join and a merge join. When the DB2_HASH_JOIN registry variable was set to YES, the optimizer was also able to consider using a hash join when optimizing the access pl
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help