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.