Re: Reducing size of .dat and .idx in SE5.02

> Would anybody like to explain the most quickest and reliable > way to reduce the sixe of a .dat and .idx file is your database.dbs > directory . After archiving certain orders from one of our Systems > the dat and idx files do not reflect the deletions we have done > > I know we can dbexport and dbimport pretty easily which might also > help with fragmentation of some of our large table .Can the Alter > Index statement help me here ? Try ALTER INDEX indexname TO CLUSTER. It will take some time. You will also need enough disk space for the current size and the new size to be on disk at the same time. Actually any ALTER TABLE should also work. > > Cheers > > Noel O'Brien > > SE v5.02 > 4GLv4.12 > AIX 3.2 Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc