On 7/23/06, Hartwig Wiesmann <[EMAIL PROTECTED]> wrote:
Hello,
I have read somewhere that BETWEEN is faster than the equivalent
expression using comparison operators.
Example:
... WHERE Column BETWEEN 1 AND 10
compared with
...WHERE Column >= 1 AND Column <= 10
between is definitely NO
It used to be the other way around (between was slower, wouldn't use
index), but now one of them is optimized into the other, can't
remember which.
On 7/23/06, Hartwig Wiesmann <[EMAIL PROTECTED]> wrote:
Hello,
I have read somewhere that BETWEEN is faster than the equivalent
expression using co
Hello,
I have read somewhere that BETWEEN is faster than the equivalent
expression using comparison operators.
Example:
... WHERE Column BETWEEN 1 AND 10
compared with
...WHERE Column >= 1 AND Column <= 10
The reason might be that for the first expression the column value
has to be ret
3 matches
Mail list logo