Re: Data deletion in Informix

> > If I have done a mass deletion on tables, when I do a tbstat -d , I don't see > the space being free up. Is it the space was free logically but not > physically ?? > There are now empty spots for rows in your tables, like swiss cheese. To de-fragment the holes, sometimes "alter index to cluster" is quite helpful and easy. Sometimes, you need to rebuild the table (select from old insert into newtable). -- Naomi Walker (aka N7FSA) | naomi@anasazi.com | Phoenix, Arizona ----------------------------------------------------------------- Dyslexsics, Untie! | Visualize Whirled Peas