Optimization - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Optimization

Author

Topic

Ranjit.ileni
Posting Yak Master

183 Posts

Posted - 2011-07-19 : 03:12:25

Hi ,

I prepared same query in following 3 ways

1) using NOT IN
2) using LEFT JOIN WITH NULL
3) using NOT EXISTS

then the Query cost is same i.e., 33%,33%,33%

at last Performance wise which method i should use in Real Time.

Need Suggestions .

Thanks ,

--Ranjit

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-07-19 : 03:15:45

http://connectsql.blogspot.com/2011/05/sql-server-which-performs-better-in-or.html