Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: table partitioning - max number of rows
The figures you give are perfectly reasonable for partitioning.
Depending on how you intend to load the data though, how long you want to keep it, and how frequently you expect to clear it down, you might find one partition per day more effective. And at 25 bytes per row, you might want to consider partitioned IOTs.
-- Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Heiko wrote in message ...Received on Mon Apr 08 2002 - 10:15:59 CDT
>Hello,
>
>i'm going to set up a table containing meassurement data. This table
>will have approx. 7 million rows inserted each day (2000 million each
>year). The average row size is about 25 bytes.
>
>Is a table of that size too big for partitioning (I intend to create
>one partition per month) ? Is there a limit on how big a partitioned
>table should be?
>
>Is it better to split the data into several tables?
>
>Thanks for your help.
>
>Heiko
![]() |
![]() |