Re: Avg Row size

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.com>
Date: Tue, 18 Feb 2003 19:23:31 GMT
Message-ID: <TKv4a.165826$be.147856@rwcrnsc53>

You could analyze the table and look in the data dictionary or determine how many rows (select count(*) from mytable and divide it by the table size, blocks * block size)
Jim
"Subroto Mukherjee" <submukhe_at_cisco.com> wrote in message news:1045595633.358106_at_sj-nntpcache-5...
> Hi SQL gurus,
>
> Can somone tell me how to calculate the Avg Row size for any given
> table.
>
> Thanks a bunch in advance
>
> --
>
Received on Tue Feb 18 2003 - 13:23:31 CST