Re: no index used

En steinhoefel@dcs-systeme.de va escriure el dia 25 Feb 00, a les 13:02: > 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 > > You have 2 possibilities: a) try to change the OPTCOMPIND parameter in your onconfig to 0 (restart your server). b) update your IDS to a new version (7.3X.XXX). In this version you can force the index usage. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------