Re: informix does not use indexes?

You should run update statistics. It is up to Informix optimizer, if it will run index or sequential search. If data has only a few data types (M-male adn F-female) the optimizer use sequential search (index search would have no effect). And you should run update statistics to supplay optimizer with data so it can decide if it wil run indexes. (if ther is a little data also seq. search is used) Bye Peter ProzessDV wrote in message <19981022044515.03961.00004046@ng34.aol.com>... >OWS 7.22 on SCO UNIX: > >The following SELECT-statement in dbaccess takes a long time until I get a >result , although I have declared an index on col4 (the table "table" has about >400000 rows). But when I use "set explain on" and look at the output of this >statement, I see that there is no index used for the search, just SEQUENTIAL >SCAN. I also tried to set optimization high or low. > >select * from table where col4 = 2> >Are there any options to set so that informix uses indexes, maybe? >