The partial path really cannot be safely reused in all circumstances. So for safety reasons we only match complete matching paths for reuse of the physical SQL join.