Re: alter index

Posted in 1998

Clint Kunz — Thu, 30 Jul 1998 19:35:31 -0600 — source: Informix-list mailing list archive (1991-1998)

>The dbexport/dbimport commands would defrag a whole database. You could >use UNLOAD/LOAD commands in SQL for a single table. > >Cheers, >-- >Mark. > What about using onunload/onload, It has been recommended to me as the fastest way to export/import the database/table, and I understand that it wil create the tables back into a single extent. I haven't tried it yet, but I would like to know if any one else has done this, and if it works? Thanks Clint G, Kunz