Re: Actual Used space

For those who are in question: In Informix 5.X in the Informix Guide to SQL Reference Dec 1991 page 2-25 NPUSED is defined as: "number of data pages in use". For Informix 7.1 in Same book page 2-40 it states the same thing! Get the npused value from a table, execute an TBCHECK -pT on that table and notice the difference in numbers. Believe me I did on my 5.X engine ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Thu, 12 Sep 1996, Mark D Stock wrote: } Cheryl Kendricks wrote: } > } > In all of this conversation no one has commited that npused is the DATA } > size only! If my memory servers me correctly npused does not include the } > INDEX size that is being used by the table. This to me is important when } > you are want to factor the amount of space a Table is using. } } I thought it was the number of pages used, regardless of type. But then this begs the } question; are free pages included? If they are, then this isn't much good. } } Cheers, } -- } } Mark. } } +-------------------------------------------------------------------------+ } |Mark D. Stock - The West Solutions Group http://www.west.co.za | } | | } |mailto:marks@west.co.za +------------------------------------------------+ } |Tel: +27 11 803 2151 |If it doesn't work... force it! | } |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | } |Cell: +27 83 250 2325 |Well, that's how I code anyway! | } +------------------------+------------------------------------------------+ } }