July 29, 2012
priority of expression in where clause and OR condition :
- Integer comparison
- String comparison
- Integer ANY/ALL/IN
- String ANY/ALL/IN
- 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.
October 6, 2011
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….
Google: let google to find…:-)