I want the performance of IN(),NOT IN(),EXIST(), NOT EXIST(), LIKE(), NOT LIKE() In sql 2005
Which one is slower in execution and which is best to fetch records as per execution time.
Anybody have any ideas ?

Nope, I can't understand what you're asking at all. Maybe someone else will, but I think you'd be better off if you tried to rephrase your question.

-PatP

Hi Anushree,
I am also facing same question.
It will be appreciated if you could post the answers if you have.
Also have one more question searching answer from last 2 years.....

The answers are:

1) It depends on the data
2) It depends on what criteria determine "best"
3) Yes.

-PatP

As Pat said. Typically, though, exists and not exists should be faster, due to they only look for a single occurence of some condition. Though, there are times that the IN can be used for index matching and it would be faster.
Dave

No sig spam yet? You guys are getting lazy.