January 17, 2020 at 8:19 pm
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.
January 17, 2020 at 8:57 pm
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
January 17, 2020 at 10:38 pm
You could also put it in a zip file and upload that to the site.
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy