Re: Releasing extents from a table.

As Andy has mentioned Raw is exeptionally quick 1M+ rows per second but the absolute killer is the re-indexing. Andy Kent wrote: > > Not necessarily. If you create the new table as RAW then inserting > into it is EXTREMELY quick. However you have to ALTER it back to > STANDARD before you can put any primary key or indexes on it. Unless > the table has loads of indexes (including rowids) on it this is likely > to be a lot faster than two operations with HPL. > > Andy > > "Jack Parker" <vze2qjg5@verizon.net> wrote in message news:<bv48ji$npj$1@terabinaries.xmission.com>... > > Unload, drop, recreate and reload. See the Informix Load FAQ. > > www.artentech.com/downloads.htm > > > > If you are using XPS you could just create a copy of the table, but with 7x > > or 9x you'd want the performance of the HPL to move the data around. > > > > cheers > > j. > > ----- Original Message ----- > > From: "JAMES SWALLOW" <JSWALLOW@greenbay.k12.wi.us> > > To: <informix-list@iiug.org> > > Sent: Monday, January 26, 2004 11:30 AM > > Subject: Releasing extents from a table. > > > > > > > I am in need of some general information about releasing extents from a > > table that I will be trimming and releasing those extents back to the > > database. The information I have at hand is not clear about this process. > > > > > > Thanx, Jim Swallow GBAPS > > > > > > > > > > > > sending to informix-list > > > > > > sending to informix-list -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #