Re: Partitioned Table Configuration

KMART wrote:

> Would like input on configuration of partitioned table that grows at
> the rate of 8 million rows per day. This is approximately 1.5g of
> storage per day.
> Comtemplating tablespace(s) with multiple data files across six mount
> points with initial and next allocation of 1G.
> Partition question:
> Data is retrieved primarily by day or day and hour of day. Two sub
> categories exist, would partitioning by month or partition for each day
> provide the greatest performance gain when selecting data based on
> single date or multiple dates? Data would be maintained for
> approximately 3-7 years before archived.

Partition by day as a trial scenario and then partition with more granularity if required by testing.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)