RE: Change next extentsize for indexes

> Date: Tue, 8 Dec 2009 13:58:13 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: Change next extentsize for indexes > > pow wrote: > > Hi, > > > > Is there a way to change the next extent size for indexes similar like > > for tables? For tables the syntax is 'alter table <tablename> modify > > next size <newsize>' > > No. The extent sizes for indexes, are (IIRC) a proportion of the size of > the table extents. So, if you change the table's next extent, you should > also change the indexes' next size. > Ok, And what happens if you drop and recreate the index? Does the size of the extents automatically change to reflect the current table size? By this I mean suppose you created the index when the table had 100,000 rows. You didn't change the default extent size so its relatively small... The table now has over 10 million rows. If you drop and recreate the index, will it still try to create its extents in proportion to the table's extents or will it create a larger first extent and then smaller (yet still large) next extents? IMHO this sort of auto tuning makes sense, although I'm not sure that IDS does this sort of thing ... But hey! What do I know? I'm not a DBA. ;-) -G _________________________________________________________________ Get gifts for them and cashback for you. Try Bing now. http://www.bing.com/shopping/search?q=xbox+games&scope=cashback&form=MSHYCB&publ=WLHMTAG&crea=TEXT_MSHYCB_Shopping_Giftsforthem_cashback_1x1