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

In article <6i8hks$i23$1@news.xmission.com>, ssoman@omm.com writes > > >Hi all, > I had a table with 32 extents ( about 5GB in total size ), I re-organized >this table by creating a copy of it in a seperate new dbspace with the first >extent size calculated to be 10% more than the current size, and the next extent >being 20% more for growth. I ran an "insert into newtab select * from oldtab", >and guess what, I end up with 2 extents, not one as I expected. Each extent is >in a different chunk. ( the first one filled up an entire chunk ) and the next >one a part of the next > I have a few questions on this scenario > > 1. Can I have ONE extent spanning over multiple chunks, or does multiple >chunks mean multiple extents ( assuming there is nothing but that table on those >specified chunk(s) ) > If the latter is true, does that mean that any table > 2GB CAN NEVER have >only ONE extent. Correct. > 2. I re-organized two tables in the same method, and ran the "insert >into..." parallelly. Would this interfere with space allocation, or does >INFORMIX pre-allocate space, and when ? Informix allocates the first extent when you create the table. It adds other extents when the first one fills up. > 3. When I create the indexes on this table ( which takes up more than 2.5 >times the data space ), will that be treated the same way as the data pages ? Yes, the index and data pages are stored in the same extent i.e. all mixed in together unless you fragment the index differently to the data or create a unique index. > 4. How do I find out where the indexes of a table are located ( physical >disk/chunk ) > dbschema -d <database> -t <table> -ss oncheck -pe oncheck -pT <tablename> >As usual, thanks for your responses > >Sujata > >***************************************** > Sujata Soman > > > E-Mail: ssoman@omm.com > > O'Melveny & Myers, Los Angeles > >****************************************** > > > > > > > > > -- 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