Tag: IBM

Community

Joining in DB2 UDB

(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

Community

The Power of Insight

(Janet Perna and Andrew Warzecha) Businesses are facing a formidable challenge: the pressure to grow revenue, contain costs, respond more quickly to changes, and increase efficiency. These big goals demand that people and processes have access to the right information at the right time to take the a