| Subject | ORs in Where statement |
|---|---|
| Author | Chris Meelhuysen |
| Post date | 2003-06-12T21:02:14Z |
Is Firebird constructed in such a way that when one OR condition is true
that it doesn't calculate the rest since we already know it can be used?
such as if i have a
where thisvalue = 1 or thisvalue =2
if my value is 1 then it never checks to see if my value equal 2 because i'm
already good to go.
or does this type of thing not work like this within an SQL database?
that it doesn't calculate the rest since we already know it can be used?
such as if i have a
where thisvalue = 1 or thisvalue =2
if my value is 1 then it never checks to see if my value equal 2 because i'm
already good to go.
or does this type of thing not work like this within an SQL database?