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

I tend to not think about partitioning except under the following conditions.

1. The size of single tables is approaching the hundred megabyte range.
2. The hardware will support it, meaning there are a sufficiently large number of individually mapped hard disks. There is no point in partitioning if each partition is not on a separate disk.
3. There are performance problems that can be related to disk I/O.

Others undoubtedly will have different criteria.

Daniel A. Morgan Received on Thu Jun 28 2001 - 06:25:27 CDT