Re: sql question for purge routine

Posted in 1997

MarkDenham@aol.com — 3 Jun 1997 00:28:30 -0400 — source: Informix-list mailing list archive (1991-1998)

Do you not bother with any of the following: 1) Constraints 2) Selecting specific dbspace for the table/indexes 3) Fragmentation 4) Sizing the table On the tables that you drop/recreate? Apart from this, the only other disadvantage I can think of with this approach is the amount of space you require in the database to create a duplicate of the table prior to dropping the original. Mark MarkDenham@aol.com (home) Denham.M@amstr.com (work)