Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Guillermo Labatte — — source: Informix-list mailing list archive (1991-1998)
Hi,
I have been told that
select * from table1 where col between value1 and value2
is faster than
select * from table1 where col>=value1 and col<=value2
Is that true for Online 5.07?
How about
select * from table1 where col in (value1,value2,value3,value4, ...)
vs
select * from table1 where col=value1 or col=value2 or col=value3 or ...
?
Thanks
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.