Re: is there limit to number of partitions in a table

colin_lyse wrote:

> we have a very large table (starting at 1 billion growing by 4 million a day
> we will keep 2 years - 2 billion rows) that has to be partitioned. Is there a
> limit ot number of partitions, not necessarily a physical limit, more of a
> partical limit. We are thinking of creating ~104 partitions (1 per week, 20
> million rows), is that execessive.
>
> what if we subpartion each of those by say 4 partition giving us 416
> partitions is that execessive will it cause problems for us?

No limit you are going to reach in your lifetime.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)