Re: disk space

If the table is already loaded, then try

select ( sum(vsize(column1)) + sum(vsize(column2)) + ..... sum(vsize(columnN)) )/ count(*)

   from table_name

This will give you average number of bytes per record. If you take out division by count(*)
in the above statement then you will get the actual bytes used by the data in that table.

suresh.bhat_at_mitchell-energy.com

Ed Lufker <elufker_at_swcp.com> wrote in article <6femob$c8g$1_at_sloth.swcp.com>...
> Hi All:
>
> Is there a formula to calculate how much disk space you are going
> to use once you have entered data into all tables.
>
>
> thanks
> eddie lufker
>
>
Received on Thu Apr 02 1998 - 00:00:00 CST