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.
Poul Pedersen — — source: Informix-list mailing list archive (1991-1998)
> 26-Oct-1994
>
>I can not understand the Informix Query Optimizer !
>---------------------------------------------------
>
>
>I have a fine large table and I create a query, where I select all fields from
>the table. To lookup the records I have an unique index on a field called
>'gd_kontonr' and as a second want, I have a filter 'gd_prod_kode < 90000'.
>
>select * from ks_gdkonto
>where gd_kontonr = "0003573508"
>and gd_prod_kode < 90000;>
>This one takes loooooooong time to run....................
>
>
Snorry Bergmann wrote:
Have you tried to UPDATE STATISTICS?
Yes Update Statistics was executes before the query and the number of rows
from the systables 'nrows' match a select count(*) on the table.
Regards
-----------------------------------------------------------------
Databaseadministrator Poul Pedersen
Kuwait Petroleum (Danmark) A/S
Hummeltoftevej 49 Mail: pp@q8.dk
2830 Virum Voice: +45 45 98 45 94
Denmark Fax: +45 42 85 14 18
-----------------------------------------------------------------
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.