Why is this query slow?

Question

Why is this query slow?

January 17, 2020 at 8:22 pm

This was removed by the editor as SPAM

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

kfrancis25 SSC Enthusiast Points: 182 More actions · Answer 1

Attached is an actual plan and the current entire query. We did make some changes based on some of the feedback, so you'll see it's different than the original.

kfrancis25 SSC Enthusiast Points: 182 More actions · Answer 2

And now the second try:

Attachments:

You must be logged in to view attached files.

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

Paste the plan is probably better than this.

Well, if I'm looking at the right query plan, #10?, it looks radically different. 1 row out 4 estimated? The last one was estimating 20,000 rows. Was it really the same? If so, looks like it may be a win. There are some key lookup operations you could try to eliminate, but estimated four rows actual 1 is pretty happy.

How is performance now?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

You could also put it in a zip file and upload that to the site.

kfrancis25 SSC Enthusiast Points: 182 More actions · Answer 5

Here's the plan, zipped.

Attachments:

You must be logged in to view attached files.