Space each table occupies

> Is there a informix utility which can let me know the space each table > occupies? > Also from what I understand, in a table there may be some spaces which are > blank. Is it possible to know how much of the space of the table has > actual data. > > Thanks > > Vinay. You can use "tbcheck -cI -pI dbname > filename" to print a report of space usage by table. The interesting things for you are the "number of pages used, allocated" rows. RTFM about this command, there are lots of options. A pet peeve of mine is how people worry about reclaiming "unused space". IMHO, a table should occupy a fairly stable space, fluctuating between purge cycles. These cycles should be defined and planned for at the onset of the project, not added in at year-end by the new DBA whose first job is to get the database back up from its "unable to allocate next extent" error. Whew! __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|