Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Perfomance with Partitioning

Perfomance with Partitioning

From: Can <no_at_spam.net>
Date: Sun, 14 Dec 2003 09:52:26 GMT
Message-ID: <upWCb.58155$dt3.47200@news.chello.at>


Hi,

I've got a table holding data dispersed over a period of 1 year....but I often just need access to the last week. Well, the first thing I thought of, was: I could improve the access performance on the last week's data perhaps by partitioning the table...

The actual question is: Is there a way of "structuring" my table in such a way that the partition holding last week's data never holds more than last week's data (->as soon as the data becomes old, it would have to move into a different partition)?
A range partition over the "date" column of the table would fullfill the first requirement (=last week's data) but, but the size of the last week-partition would grow because of new data being inserted into the same partition...
My goal is to keep the last week-partition permanently as small as possible, in order to achieve a performance gain.

Hmm, does anyone have any ideas? (Maybe it's a default issue with a standard answer :))
Thanks in advance...

Kind regards,

                        Can
Received on Sun Dec 14 2003 - 03:52:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US