Re: no index used

UPDATE STATISTICS From: steinhoefel@dcs-systeme.de > >our informix 7.22 database server refuses using indexes at all. Even if >I do a very simple query like "select kee from table1 where kee = 5" >where kee is an integer column and has an index with just that column >the index is not used. Even the primary index is not used. The table has >250000 rows. The query plan is always "sequential scan". How can I >"switch on" the indices, or how can I provide a query plan manually? >The indeces are there (to be seen in the database explorer and the >creation of another index is forbidden by the system with the message >"index already defined for that column" (or so)), and I have already >updated the statistics. >We have the same database (created by the same sql script) in ms sql >server, there's everything fine. > >Thank you in advance >Jens Steinhoefel > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com