I'm getting a poor performance from this query and was wondering if there is an alternative to using the EXISTS in the WHERE clause?
Are you able to get the latest version of Plan Explorer and provide an actual plan using that ?
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 x664
plan explorer upload x474
poor performance x111
asked: Sep 05, 2017 at 11:01 AM
Seen: 34 times
Last Updated: Sep 05, 2017 at 10:01 PM
How can I further optimise this query?
SQL Sentry Plan Explorer - SQL Execution varies from 8 seconds to 20 Minutes Because of Where Clause
Index Seek but high cost
Same Query, Two Plans, One Stinks
Suggestions for improving performance of query
any help with this runs 45 min
Component running slow
Is there a better way to search for matches
Help with query optimization
Function call as INNER JOIN causes slow RID lookup
© 2013 SQL Sentry, Inc. All rights reserved.