Re: How to calculate avg row size

From: <rspeaker_at_my-deja.com>
Date: Wed, 26 May 1999 17:39:16 GMT
Message-ID: <7ihbk4$3fl$1@nnrp1.deja.com>

this is a good way to do it, just be sure to delete your statistics as soon as you are finished or you may run into some performance issues...'

-Roy

In article <7iefr6$9t$1_at_nnrp1.deja.com>, mpir_at_compuserve.com wrote:
> 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.---
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 26 1999 - 12:39:16 CDT