• There are lot of stuff u can do to improve this query. First thing I would recomend is Upadating the stats on most of the tables in the query.

    I have attached screen shot that contains one example. THe diffrence b/w the actual number of rows and estimated number of rows is huge. That is clear indication that statiscs are skewed.

    Regards.