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?