Re: reducing size database

From: Ivan Muravyev <ivanm_at_mastech.com>
Date: Tue, 24 Aug 1999 13:57:24 -0400
Message-ID: <37C2DD04.B2468450@mastech.com>

More performance, AFAIK, you can gain by distributing your data using Partitioned table (feature of Oracle 8).

Han Zijlstra wrote:

> Hello,
> W're developing a database with a huge amount of data in
> some of its tables (100-300 Gb).
> What is the impact on performance and maintability when the
> tables are splitted into two parts: a small but active
> part, containing 10% of the data and a large, but inactive
> part, containing 90% of the data?
> Almost all data is accessed by indexes.
>
> Thanks in advance,
> Han Zijlstra
Received on Tue Aug 24 1999 - 12:57:24 CDT