Re: initial extent is LESS THAN first extent size :WHY??

In article <6icqlk$57s$1@news.xmission.com>, jeffso@lucent.com writes > >So, similar question, if I have a large table over 5G, somehow, I delete some of >the records and make it about 3G. Now, if I issue an ALTER INDEX TO CLUSTER on >this table, what will happen? Will this operation be successful? Since there >is no chunk can be bigger than 2G and I am now trying to get a continuous spaces >for 3G. > Yes, you get one extent of 2G and one of one G. >Thanks. > > >Pete Smith wrote: >> >> >> If Informix cannot allocate an extent of the specified size it will used the >largest >> available contiguous space - in this case 2Gb and likewise for the next >extent. > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care