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.
art — — source: Informix-list mailing list archive (1991-1998)
This is basicly what I have
one table with two fields indexed
date_time and acct_number
when I run the following querry it takes to long
select * from table
where date_time > "1998-04-02 00:00:00" and acct_number = 123;
if I take the "and acct_number = 123" off it returns immediately
any way I can tell informix to user the date_time index and not the acct_number
index and still check the acct_number value
note just sample data to make my point that it is using acct_number
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.