Which one of the below operator takes the most time for execution?

Question

Which one of the below operator takes the most time for execution?

kiran.vaichalkar

Ten Centuries

Points: 1056
More actions
June 19, 2013 at 3:36 pm

#274255

Which operator takes the most time for execution?
1) IN
2) NOT IN
3) AND
4) ALL
?

Viewing 4 posts - 1 through 3 (of 3 total)

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Is not easy to answer as they're not equivalent and can't be measured against each other.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

No way to answer that. Depends on too many factors including but not limited to row count and indexes.

Question doesn't even make sense, IN and AND are not in the same class, one is part of a predicate, one is a logical operator that combines two predicates

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Sean Pearce SSCoach Points: 15999 More actions · Answer 3

kiran.vaichalkar (6/19/2013)
Which operator takes the most time for execution?
1) IN
2) NOT IN
3) AND
4) ALL
?

Your question makes this much sense:

I have a Sharp Calculator, which operator takes the most time for execution?

1) +

2) -

3) /

4) *

?

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]