SQL Access Path Enhancement - Second of the day
MartinPacker 11000094DH Visits (1776)
I'm deeply involved in a nice complex study at one of my favourite clients at the moment - so I've just
So APAR PK15890 is my second SQL Access Path Enhancement of the day...
Take the case of a query like
where T2.C1 is the partitioning column of the T2 table.
Suppose further that Hybrid Join was the chosen access path and that T2 was accessed as the inner table via List Prefetch.
Prior to PK15890 Page Range screening would not be used to limit the scan of T2 to a subset of its partitions. In this example you'd want the only the partitions where the
T2.C1 < '2003-12-31'
local predicate is true to be scanned.
The fix will be made available for both Versions 7 and 8.