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)
31-Oct-1994
> 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....................
>
>
Well done Tom Hogarty,
select * from ks_gdkonto
where gd_kontonr = "0003573508"
and gd_prod_kode < '90000';
the gd_prod_kode is a char(5) field and not a numeric field.
The select executes perfect now.
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.