difference between in and exists in sql server as performance
  • I want to know difference between in and exists clause in sql server that which is faster.
  • 1 Comment sorted by
  • Vote Up0Vote Down WaqasWaqas
    172.00 Karma Accepted Answer
    IN is slower than EXIST because IN search in whole table.

    EXIST is faster than IN because EXIST just search for required row.

    So EXIST is faster than IN according to performance.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Tagged

Popular Posts of the Week

Optimum Creative