Post reply

Exists Vs Not Exists . Which one is Better?

  • June 28, 2007 at 1:00 am

    #715735

    Thanks for all your replies .. i too tried on many tables and was tried to compare execution plans .. but i too feel that exists and not exist would execute the same way 

    first  it would execute the select query .....

    second check whether any rows are retured ...

    and then perform a not operation if the condition is not exists...

    the performance will depend only on the select query what we write

     

     

     

    Kindest Regards,
    Paarthasarathy
    Microsoft Certified Technology Specialist
    http://paarthasarathyk.blogspot.com

  • June 28, 2007 at 2:24 am

    #715759

    COOL!

     

    Now we are on the same page!

    Thanks evryone for sharing their thoughs.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply