Re: Sizes of "large tables"

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Tue, 19 Feb 2002 18:06:33 GMT
Message-ID: <3C729438.25B9AB9E@ci.seattle.wa.us>

I would seriously consider partitioning anytime the tables are in the gigabyte range and the queries used against it are such that most queries can benefit from being able to go against or, or only a few, partitions.

Daniel Morgan

godmann wrote:

> HI Pete,
>
> Is there any other way to deal with PRAY-FOR-ME type of tables
> other than partitioning it? Are all tables reaching 1 terabytes need to be
> partitioned?
>
> As for me I only see tables of GB not tera!
>
> Allan W. Tham
> DBA
Received on Tue Feb 19 2002 - 12:06:33 CST