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.
Guru — — source: Informix-list mailing list archive (1991-1998)
Hi,
I have a table which has a date-time column as part of the key
If my select statement has "BETWEEN" two date-time values,
will the engine use the date-time column as part of the index?
ie select * from table
where dte_tme between value_a and value_b
where the key is dte_tme
is the index being used here?
this is on SE version 7.12 on SCO openserver 5
(please respond by e-mail as well)
Thanks
Nils Woxholt
nils@quantum.co.za
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.