I have started tuning queries recently. Apart from the obvious Table Scan in this plan, can you please point me in the right direction. I would really appreciate your inputs Thank you Jack
This is only an estimate. Can you attach the actual plan ? Can you also run the inside of the view so we can see how it is constructed ?
Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.
Answers and Comments
query plan x691
plan explorer upload x502
execution plan x125
poor performance x116
performance tuning x19
asked: Jul 25, 2017 at 01:59 PM
Seen: 970 times
Last Updated: Jul 25, 2017 at 11:13 PM
Two Servers. Two radically different plans.
Any ideas to increase performance of this query?
Same Query, Two Plans, One Stinks
Component running slow
Is there a better way to search for matches
Execution plan mystery
Any idea why the filter limiting to 5K instead of 320K rows is done at the end ?
How can I improve this plan. Table Insert is costing the most at 84.6% - can it be improved ?
A filter with the attached query causing slowness and performance issues
Trying to understand why partition elimination is happening in some plans, but not others
© 2013 SQL Sentry, Inc. All rights reserved.