Re: estimate table size

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 25 Sep 2001 18:51:08 +0100
Message-ID: <3BB0C40C.C84@yahoo.com>

Ken Chesak wrote:
>
> Version is Oracle 8.1.7 on NT.
>
> "Ken Chesak" <ken.chesak_at_dhs.state.tx.us> wrote in message
> news:75f49d83.0109241054.37a8c136_at_posting.google.com...
> > I would like to know the best way to estimate future table size in
> > megs based on exepected number of rows. The tables are created but
> > they are empty.

There are plenty of algorithms out there, but the best way is load some sample data, run an analyze, and extrapolate from there.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Tue Sep 25 2001 - 12:51:08 CDT