dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: T-SQL Performance--NOT IN vs NOT EXISTS

Learn the difference between using not in and not exists in T-SQL.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Avoid using NOT IN whilst comparing nullable columns. Use NOT EXISTS instead.

When NOT IN is used in a query, SQL Server compares each result to null (even if no rows are returned). NOT EXISTS does not perform a comparison with nulls.

 

Visit the DevX Tip Bank

 





   
Thanks for your registration, follow us on our social networks to keep up-to-date