RE: inf 9.2 taking much more space than 7.23

Rumor has it that each index item has an additional 8 bytes of overhead. Scott H. > -----Original Message----- > From: Roy Mercer [SMTP:roy_d_mercer_1234@yahoo.com] > Sent: Wednesday, September 06, 2000 8:34 AM > To: Informix List > Subject: Re: inf 9.2 taking much more space than 7.23 > > 9.X is taking up more space because the 9.x release > stores all indexes in their own TBLSPACE. > > If you look at on oncheck -pt you will find your > indexes have been detached. > > All of you 7.X extent sizing included indexes. > When you import the indexes are taking their own > space and the table has now used the space figured > for the indexes. > > You will have to downsize your extents for 9.2 > to not include the indexes. > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Mail - Free email you can access from anywhere! > http://mail.yahoo.com/