Re: Table partitioning question

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