Query: we inject redundant MaterializeCollectionNavigation calls into some queries that take advantage of correlated collection optimizations #10733
Labels
area-perf
closed-fixed
The issue has been fixed and is/will be included in the release indicated by the issue milestone.
type-enhancement
Milestone
During nav rewrite, if we see "naked" collection navigation we inject MaterializeCollectionNavigation call. However, later in the pipeline we can optimize some of those collections using with the CorrelateSubquery pattern. CorrelateSubquery performs materialization itself, so the outer MaterializeCollectionNavigation call is no longer needed.
The text was updated successfully, but these errors were encountered: