Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Partitioned Table Configuration
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.
Received on Tue Apr 12 2005 - 16:42:25 CDT