slow query – require help in tuning the query

PavanA 2015-08-06 14:58:28

Hello Team,

I have done the index rebuild & update statistics for the tables reference in the query. The query takes more than 7 min to execute (sometime more). Could you please guide/suggestion to me how can i tune the query?
link text

Thank you,
Pavan A

SQLkiwi 2015-08-11 04:24:16
Are you able to run the query directly from Plan Explorer? That would provide useful performance information about I/O, parameters etc. that would make suggestions easier. You can edit your question to attach the resulting PE session file. If you could provide existing table and index definitions in another separate text file, that would be great too. If you can't do any of that, let me know, and I'll give you what I can on the basis of the SSMS file alone.