Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> When to use partitioned tables ?

When to use partitioned tables ?

From: Francesco Marchioni <fmarchioni_at_libero.it>
Date: Thu, 28 Jun 2001 07:23:58 GMT
Message-ID: <iYA_6.3692$z11.404091@news.infostrada.it>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US