Re: alter index

Posted in 1998

Kadlcik Vaclav — Fri, 31 Jul 1998 06:23:50 GMT — 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 Yes I use to do so (onunload/onload the whole database). It seems to be the easiest way. Vasek