In(),not In(),exist(), Not Exist(), !like()

AnushreeDarshane · #1 (**permalink**) 07-03-09, 03:32

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 ?

Pat Phelan · #2 (**permalink**) 07-03-09, 03:57

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