Consolidate Execution Plan Paths - by lasa

Status : 

  Duplicate<br /><br />
		This item appears to be a duplicate of another existing Connect or internal item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 800096 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 9/10/2013 1:54:06 AM
Access Restriction Public


When the execution plan contains multiple paths with identical sections, these could be consolidated and only executed once, instead of once per path. See the example in the attached script where three paths could be consolidated, with a substantial gain in performance. 
Sign in to post a comment.
Posted by Vassilis [MSFT] on 9/16/2013 at 7:02 PM
Dear customer -- Thanks for taking the time to propose this improvement. There is a long-standing Connect feedback item that advocates a similar approach:

Best regards,
SQL Server product team.