Re: When to use partitioned tables ?

Francesco Marchioni wrote:
>
> Hi all,
> I'm studying how to partition a table. I wonder what are
> the standards about this: for example how many records
> you need to have in your Table in order to start thinking
> about partitioning ? I speak about an ordinary sized table...
> I just want an advice if 10.000 records are worth partitioning
> or you should have about 1.000.000 in order to outweigh the
> cost of partitioning (I think that there must be some overhead
> in your query when you use a partitioned a table)
> Thanks
> Francesco

As well as the other post, if you have very concurrency you could hash partition it to spread the load over various segments..

hth

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."