Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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)Received on Tue Apr 12 2005 - 23:54:31 CDT
![]() |
![]() |