Re: Table partitioning question

Thank You, Billy, for Your confirmations. I see that we have to do a workaround in _Forms_.
This is for the other NG ...

And thanX to all for quick response.

Jan=)

"Billy Verreynne" <vslabs_at_onwe.co.za> schrieb im Newsbeitrag news:ask5s3$kda$1_at_ctb-nnrp2.saix.net...
> Jan Gelbrich wrote:
>
> > I do not have experience in partitioning, so I want to ask You, if
> > You would or not partition a table "Person" under the follwing
> > circumstances:
> <snipped>
>
> No.
>
> Primary reason is that I fail to see what the benefit will be using
> partitioning.
>
> > would any partitioning be helpful at all to this,
> > e.g. partitioning Person by the first letter of the surnames ?
> > Remember, I am dealing with "just" 1 million rows, that should be
peanuts
> > for Oracle ?
>
> I'm using partitioning on a fact table in a warehouse. Partitioned on
> processing month (between 40 and 70 million rows per month). The partition
> does not aid any just querying, but data management. The fact table has
> over half a billion rows. To age a month (remove all data for that
> processing month from the table). Sub-second response. To add a new
month's
> data into that table. With indexes. Sub-second response. Damn, sometimes
> you can not help liking Oracle. :-)
>
> Some of the other fact tables are also pretty large (totals around 70 or
so
> million rows). Not partitioned. I do not see any query performance
benefits
> even if I do (and yes, I did try). The current indexing strategy works
> fine.
>
> Creating a partitioned table, simply to solve a single specific query
> response problem... that is not something I personally would consider.
>
> --
> Billy
>
Received on Wed Dec 04 2002 - 01:35:47 CST