Re: delete very slow with SE ?

Frederic_Bouquet@ascus.com (Frederic Bouquet) wrote: >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. I seem to recall problems with SE when rows are often deleted and inserted - something about the tables or index files getting larger and larger because deletions are actually just marked rows. You might try making a clustered index which will reconstruct (clean) the table and indices. Just a thought... John H. Frantz Alive in Iceland