Alternative to using EXISTS in WHERE clause

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?

avatar image By AndrewL 0 asked Sep 05 at 11:01 AM
more ▼
(comments are locked)
avatar image Matak Sep 05 at 10:01 PM

Are you able to get the latest version of Plan Explorer and provide an actual plan using that ?

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

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

Follow this question

Topics:

x641
x455
x109

asked: Sep 05 at 11:01 AM

Seen: 28 times

Last Updated: Sep 05 at 10:01 PM