Need help in optimizing the plan

Hi SqlSkills Team,

I would need your valuable suggesstion to optimize this query plan.

I have done index rebuild for all the indexes in the table

and update statistics fo all the tables Exec sp_msforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN;'

Kindly give suggestions to reduce the execution time from 13 seconds to few milli seconds Also, how to fix the tempdb spill warning

tmpB1A1.pesession (136.3 kB)
avatar image By Anamikha 1 asked Jun 08 at 09:35 AM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort voted first
avatar image By Hugo Kornelis 271 answered Jun 09 at 08:44 AM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

We are Moving!

<p><br></p>

Follow this question

Topics:

x691
x502
x4

asked: Jun 08 at 09:35 AM

Seen: 48 times

Last Updated: Jun 11 at 03:20 PM