RE: no index used
Posted in 2000
Topics: Performance & Tuning
How many rows do you get back for this query? Did you try update statistics high on kee? What is the exact query plan output? Will >===== Original Message From steinhoefel@dcs-systeme.de ===== >Hi, >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 ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------