Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stephen Tirone Caution with EXCEPT RE: Caution with EXCEPT
jdurandt
SSChasing Mays
Points: 628
More actions
January 18, 2010 at 8:20 am
#1104961
That's interesting
I benchmarked EXCEPT vs WHERE NOT IN (SELECT .....), and for my dataset, server, DB version etc. the performance results were equivalent, or biased towards EXCEPT.
Can you give more details about your scenario?