Re: Extent size when rebuilding a table

From: chris <cwalz@mayn.de> > >use in ur create table statement >create table ... >{... >} >extent size SIZE >next extent size SIZE NEXT SIZE, not NEXT EXTENT SIZE. >c-eriks@algonet.se wrote: > > > Hi! > > > > I'm trying out ways to reduce the number of extents for tables. The > > method I've used is the "ALTER INDEX my_index TO CLUSTER"-method. When > > allocating contiguos pages for the table, informix uses just the number > > of pages needed. Is it possible to set the size for the first extent as > > you can do for the next extent? This way I should be able to give the > > table some extra space in the extent, to grow in. > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.