Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
"Malcolm Weallans" — — 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 ?
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.