Home

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

HI,

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

Facebook:www.facebook.com/nishantcomp2512

twitter:http://twitter.com/#!/nishantcomp2512

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

LinkedIN:http://in.linkedin.com/in/nishantcomp2512

Google: let google to find…:-)

Follow

Get every new post delivered to your Inbox.