Alternative to using EXISTS in WHERE clause

AndrewL 2017-09-05 11:01:16

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?

Matak 2017-09-05 22:01:38
Are you able to get the latest version of Plan Explorer and provide an actual plan using that ?