Re: Fragmentation

hsprint@aol.com (HSPRINT) wrote: >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. First you can check to see what is going on. Run a tbcheck -pe to get a listing of all the extents, and see if you table is fragmented. If it is unload/reload it. However, when you recreate the table, set the extent size to something large enough to handle all the data. ^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^ | | | | | | | | | | | | | | | | | | | | | | | | | | o o o o o o o o o o o o o o o o o o o o o o o o o o Mark Steele 74431,3327@compuserve.com "it is nice to be important, but it is more important to be nice" o o o o o o o o o o o o o o o o o o o o o o o o o o | | | | | | | | | | | | | | | | | | | | | | | | | | v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^