Re: Fragmentation

In article <3ttpat$f9c@newsbf02.news.aol.com> hsprint@aol.com "HSPRINT" writes: > Is there an equivalent to the DOS defrag for Informix tables? Our > application is purging about 20 old records a day in some of the tables > and I am concerned about the efficient use of space. This doesn't say what version of Informix is being usedf (SE or OL). Personally I'm not sure that purging 20 records a day is a problem - how many per day are being added? However, I presume there is at least one index on the table in question, in which case running the statement 'ALTER INDEX idxname TO CLUSTER' will ensure that (until the table is altered) the physical & logical order for that index are identical Regrads -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================