Between operator

[Former Member]

Hi,

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

Regards,

Balaji Viswanath.

[Former Member]

hi,

i suggest you to use RANGES .....

Regards,

Santosh

[Former Member]

Hi Balaji ,

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

Reward points if useful.

Thanks ,

Surya Pydikondala.

[Former Member]

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