New to Query Tuning

hpjack433 2017-07-25 13:59:53

I have started tuning queries recently. Apart from the obvious Table Scan in this plan, can you please point me in the right direction.
I would really appreciate your inputs
Thank you

Matak 2017-07-25 23:13:50
This is only an estimate. Can you attach the actual plan ? Can you also run the inside of the view so we can see how it is constructed ?