Estimated Execution Plan - interpreting the results

• david_h_edmonds

  Default port

  Points: 1430

  More actions

  April 18, 2019 at 7:57 am

  #3446068

  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?