Re: moving tables

This is what Jack shared with me. It is worth thinking about... On 6/8/07, Jack Parker <jack.parker4@verizon.net> wrote: > I've seen alter fragment chew up to 6x the size of the table in logical > logs. You could create the table as raw, load it and then reset it to > standard. > > j. On 6/8/07, Eric Rowell <erowell@gmail.com> wrote: > If the table is small this could not be worth haggling over... > > But wouldn't copying also be expensive since the new table will be logged? > > How much more or less would the alter fragment be? > Since Alter Fragment handles the locking, create table, coping the > data, removing the old table, and unlocking... It is also very easy > to script... > > Eric B. Rowell > > On 6/8/07, Jack Parker <jack.parker4@verizon.net> wrote: > > Alter fragment can be an expensive operation - especially on your logical> > logs. I would copy it to the new dbspace - under another name, and then > > drop the old one, rename the new one. > > > > j. > > > > -----Original Message----- > > From: informix-list-bounces@iiug.org > > [mailto:informix-list-bounces@iiug.org]On Behalf Of fiedlert@gmail.com > > Sent: Friday, June 08, 2007 1:42 PM > > To: informix-list@iiug.org > > Subject: moving tables > > > > > > is it possible to move certain tables from one chunk to another in a > > dbspace? Any pointers on how to do this would be greatly appreciated. > > > > Another approach I was thinking was to just create a new dbspace > > altogether and use ALTER FRAGMENT. Would this be a better way to go? > > > > Ted Fiedler > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > >