Re: Help: Average Record Size

From: Geoff Ingram <g.ingram_at_chs1rh.boat.bt.com>
Date: 1995/12/13
Message-ID: <4an13u$kb5_at_pheidippides.axion.bt.co.uk>#1/1


the Bob D'Amore <bdamore_at_epsilon.com> wrote:
>
>I've got a v7 database and i'm trying to figure out the
>average record size of each table. I havent been able to
>come up with a solution. I can figure out extent size and #
>of extents, but i cant figure out how to get the % of free
>space in a table's extents. Help! Thanks.
>
>-bdamore_at_epsilon.com
>
>
>

look at "analyze table compute|estimate statistics" command in SQL Reference.

After running, this populates USER_TABLES.AVG_ROW_LEN column with exactly value you want. Received on Wed Dec 13 1995 - 00:00:00 CET

Original text of this message