Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> When to use partitioned tables ?
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
Received on Thu Jun 28 2001 - 02:23:58 CDT
![]() |
![]() |