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

Posted in 1996

"Noel O'Brien" — 1 Mar 1996 11:43:28 -0500 — source: Informix-list mailing list archive (1991-1998)

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 ? Cheers Noel O'Brien SE v5.02 4GLv4.12 AIX 3.2