Re: DELETE does not use index

Have you updated stats lately? No you can't force a particular index. Make sure column_x is a character column. If it is an integer (or any type other than char) any SQL will not use an index as you would expect. -Bill } } Hi, } } Any help with the following would be appreciated. } } I have a table (e.g. table_1) with two indexes, a unique index on the four } primary key columns and a non-unique index on another column (e.g. } column_x). When I execute the SQL: } DELETE from table_1 where column_x = 'A' } Informix does a full table scan instead of using the index. } } Is this a problem with the version of Informix - On-Line Dynamic Server } 7.11.UC1 or is there some way of forcing the index to be used? } } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net