Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
3.0
-
None
Description
Switch JOINT prefetches to OUTER Joins. This is related to CAY-1025. JOINT_PREFETCH_SEMANTICS using inner joins makes little sense and is a complete hack. Changing it to use OUTER joins suddenly makes it usable (and in fact even more robust than DISJOINT prefetches - see the problem described in CAY-1025).
Needed code was committed as a part of CAY-1025 work, so here we'll need to update the docs and the UPGRADE-NOTES.txt.