Home Forums SQL Server 2014 Development - SQL Server 2014 which is better for performance: LEFT join or NOT EXISTS RE: which is better for performance: LEFT join or NOT EXISTS

  • June 11, 2015 at 8:51 am

    #1804722

    Gail Shaw has a series of articles on her blog where she tests this options. This specific test is done here: http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    However, I would insist on following Phil's advice on doing some testing of your own.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2