Increased Opportunity for Selection of Bit-Filters

DB2 UDB v8.1.2 includes improved performance for hash joins by selecting bit filters more often (in situations where they will help). This “behind-the-scenes” feature will also improve performance of larger hash joins due to the addition of a 32-bit hash code.

Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.