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 -> Partitioning tables

Partitioning tables

From: Jenda Krynicky <Jenda_at_Krynicky.cz>
Date: Thu, 18 Nov 1999 16:15:50 GMT
Message-ID: <1103_942941750@prague_main>


I have a huge table (OK, OK ... most of you have seen bigger ;-) and would like to partition it (I think it would help performance).

One of the fields in the table is a "weeknumber" (not number within a year, but number of weeks since some date) and I think since all queries contain

 WHERE AGBWEEK >= whatever AND AGBWEEK <=something ...

this would be the best field to partition the table on. Right?

I thought I could create a partition for every N weeks.

But we get new data every week so the upper bound - the maximum week number - changes.

So ... what should I do?
Should I "prealocate" several partitions for upcoming weeks? And then repartition the table after the last partition gets too big?

Or is is possible to split the last partition when necessary ? Or instruct Oracle to create a new partition every time the partitioning field increases above a limit?

Thanks and please forgive my misunderstandings. (I'm sure there are many.) Jenda
http://Jenda.Krynicky.cz Received on Thu Nov 18 1999 - 10:15:50 CST

Original text of this message

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