sql server - is "NOT EXISTS" bad SQL practice? -


in sql server, using "not exists" in queries considered bad practice , i've heard microsoft code reviews test not exists , flag these warnings. why not exists considered bad practice , join operators preferred on not exists?

given that:

  • any reasonably query optimizer able convert between “not exists”, “exists” , "joins", there no performance difference these days.

  • “not exists” can easier read joins.

therefore don’t consider “not exists” bad practice in general case.


Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -