RE: Optimize Query for slow responce

> 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 -----------------------------------------------------------------