topic Re: Between operator in Application Development and Automation Discussions

Between operator

Former Member — Fri, 25 Apr 2008 15:17:27 GMT

Hi,

In SELECT query, which is prefered performance wise - between or GT & LT operator?

Regards,

Balaji Viswanath.

Re: Between operator

Former Member — Fri, 25 Apr 2008 15:19:33 GMT

hi,

i suggest you to use RANGES .....

Regards,

Santosh

Re: Between operator

Former Member — Fri, 25 Apr 2008 16:22:34 GMT

Hi Balaji ,

Using Ranges increases performance then using between or LT or GT.

Reward points if useful.

Thanks ,

Surya Pydikondala.

Re: Between operator

Former Member — Fri, 25 Apr 2008 17:49:11 GMT

Hi Balaji,

first of all, there is no difference in performance if you use v BETWEEN a AND b or v GE a AND v LE b. Very often people make the same error than you, thinking that BETWEEN is a synonym for GT & LT. This is not true. BETWEEN a AND b means that the expression returns TRUE if the value is equal to a, b or something in between.

The database handles both expressions as the same statement. Therefore is no difference at all regarding to performance.

Regards

Ralph Ganszky