Estimated Execution Plan - interpreting the results

  • david_h_edmonds

    Ten Centuries

    Points: 1232

    Hi all,

    Having used SQ server daily for many years, I have finally found the need/time to use execution plans in some more complex code.

    The below is my estimated execution plan for a view that contains  4 left outer joins and multiple currency conversions based on the results of those joins.

    It appears I have a sort that is costing 78% whilst most other steps don't get over 4%.

    I am wanting to tune the query to relieve this issue but unsure as to what will make a difference.

    Can anyone offer any advice please?

    Estimated execution plan

     

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply