Home Dashboard Directory Help
Search

Consolidate Execution Plan Paths by lasa


Status: 

Closed
 as Duplicate Help for as Duplicate


6
0
Sign in
to vote
Type: Suggestion
ID: 800096
Opened: 9/10/2013 1:54:06 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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.
Details
Sign in to post a comment.
Posted by Microsoft 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: http://connect.microsoft.com/SQLServer/feedback/details/218968/

Best regards,
SQL Server product team.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Consolidate Execution Plan Paths.sql 9/10/2013 1 KB