Re: Deleting Records on SE

You may also want to try the isam routine "isrm -c" which will drop the table at the isam level and re-create it with the identical index structure. Then run UPDATE STATISTICS FOR TABLE tablename. Sean Billy Wheeler wrote in message <75nkec$ibl$1@news.xmission.com>... > >On 17 Dec 98, at 8:56, Carlos wrote: > >> I've deleted all the records of a table, but the data file and the index >> file have the same size. Does anyone know what's happening? Is it normal? >> How can I decrease the size of these files? > >This is normal behaviour. Informix marks this space as reusable. To >reduce the filesize, you should drop the table and recreate it or run >an ALTER INDEX TO CLUSTER. > >HTH. > >-- >Ciao, > >Billy > >Some days it's just not worth chewing through the restraints...