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.
ProzessDV — — source: Informix-list mailing list archive (1991-1998)
OWS 7.22 on SCO UNIX:
The following SELECT-statement in dbaccess takes a long time until I get a
result , although I have declared an index on col4 (the table "table" has about
400000 rows). But when I use "set explain on" and look at the output of this
statement, I see that there is no index used for the search, just SEQUENTIAL
SCAN. I also tried to set optimization high or low.
select * from table where col4 = 2
Are there any options to set so that informix uses indexes, maybe?
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.