Re: How to calculate avg row size

From: <mpir_at_compuserve.com>
Date: Tue, 25 May 1999 15:32:53 GMT
Message-ID: <7iefr6$9t$1@nnrp1.deja.com>

Depending on what you mean by 'easy', try 'Analyze Table Fred COmpute Statistics';

This will place a whole bunch of information in sys.dba_tables, including average row size.

In article <374AB3C0.A0DF7762_at_globeset.com>, Mary Orcutt <mary_at_globeset.com> wrote:
> What is the easiest way to calculate the average size of the data
> for a row in a specific table ?
>
> Thanks,
> Mary
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 25 1999 - 10:32:53 CDT