table partitioning - max number of rows

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 Received on Mon Apr 08 2002 - 09:58:01 CDT