delete very slow with SE ?

An Informix SE kernel release 5 is installed on a SCO pentium 90 MHz. It takes 8 mins to delete at least 200 rows (or more) from a table that contains about 56000 rows !!! of course the server is not overloaded with other task. Here's the structure of this table : mou_numecr CHAR(11) mou_numord INTEGER mou_cptgal CHAR(9) mou_secana1 CHAR(6) mou_secana2 CHAR(6) mou_cptaux CHAR(9) mou_libel CHAR(30) mou_montdebf DECIMAL mou_montcref DECIMAL mou_codlet CHAR(3) mou_datlet DATE mou_montdebd DECIMAL mou_montcred DECIMAL mou_qte DECIMAL mou_immo CHAR(1) mou_numpiece CHAR(12) mou_ecrdate DATE mou_jal CHAR(3) mou_codedev CHAR(5) mou_regroup CHAR(6) mou_pointage CHAR(6) mou_transtreso CHAR(1) here's the index for this table : CREATE INDEX i_mou_cptgal ON mouvts (mou_cptgal) CREATE INDEX i_mou_cptaux ON mouvts (mou_cptgal,mou_cptaux) CREATE INDEX i_mou_ecrdate ON mouvts (mou_ecrdate) CREATE INDEX i_mou_numecr ON mouvts (mou_numecr) CREATE INDEX i_mou_pointage ON mouvts (mou_pointage) CREATE INDEX i_mou_numord ON mouvts (mou_numecr,mou_numord) here's the delete command: delete from mouvts mou_numecr="95010100001" Do you have any explanation about a so long time (8 mins) to delete so few rows ? Frederic +------------------------------------+--------------------------+ | Frederic BOUQUET | Phone : (33) 77 93 57 46 | | Cornut Informatique | Fax : (33) 77 92 51 39 | | 24, rue de la Telematique - BP 702 | AppleLink : CORNUT.INF | | 42950 St Etienne cedex 9 FRANCE | Compuserve: 100303,1061 | | frederic_bouquet@ascus.com | | +------------------------------------+--------------------------+ -------------------------------------------------------------------------- U.S.A. | AppleLink : ASCUS About Software Corporation | eWorld : ASC.US 10601, South De Anza Blvd. |America Online : ASCUS Suite 105 | Compuserve : 73243,36 Cupertino, CA 95014 | Internet : info@ascus.com general phone : (408) 725 4242 | Anonymous FTP : ftp.ascus.com sales : (800) 55 SOFTWARE | ARA Server : (408) 725 4250 tech support : (408) 725 4240 |FirstClass BBS : (408) 725 4252 fax : (408) 725 4243 | bbs.ascus.com -------------------------------------------------------------------------- FRANCE | AppleLink : ADV.SOFT ASC | Compuserve : 76034,2123 9551, route de St Laurent du Var | Internet : euro_info@ascus.com F-06610 La Gaude | Anonymous FTP : ftp.ascus.com general phone : +33 93 24 76 00 | ARA Server : +33 93 24 76 03 fax : +33 93 24 76 06 |FirstClass BBS : +33 93 24 76 13 --------------------------------------------------------------------------