Re: Partitioning tables

I would avoid a MAXVALUES partition if possible. I have a similar table, and I create a new partition about every week to hold next week's data.

Jenda Krynicky wrote:

> 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 - 16:47:23 CST