SQL sever optimization in query where clause optimization with OR conditions

Leave a comment

priority of expression in where clause and OR condition :

  1. True/False
  2. Integer comparison
  3. String comparison
  4. Integer ANY/ALL/IN
  5. String ANY/ALL/IN
  6. Subselect – that is a nested SELECT statement

removing OR condition with same column in where clause…

1)column=’text’ OR column=’text1′ OR colmn=’text2′

2)OR column in (‘text’,’text1′,’text2′)

3)column = ANY(‘text’,’text1′,’text2′)

above Or condition order in performance(min to max) aspects.




Few things about nishant

Leave a comment


I am nishant joshi from Vadodara,Gujarat area.

I have started my job as a programmer.

At collage time i have worked on many project of Java,Asp.net and also having a good knowledge of oracle,Java,c#,.net,AI,data clustering,Networking,and many more.

for any help or for contact my accounts and blogs,etc are….


blogspot blog:www.nishantcomp2512.blogspot.com



Experts exchange:http://www.experts-exchange.com/blogs/nishantcomp2512/


Google: let google to find…:-)