Re: Pros/cons of using as many table partitions as possible

Jonathan Lewis wrote,on my timestamp of 20/04/2008 4:38 PM:
> ----- Original Message -----
> From: "Noons" <wizofoz2k_at_yahoo.com.au>
> Newsgroups: comp.databases.oracle.server
> Sent: Saturday, April 19, 2008 4:15 PM
> Subject: Re: Pros/cons of using as many table partitions as possible
>
>

>> Jonathan mentioned here a few years ago
>> about using thousands of partitions
>> in a table without any major problems.


> 

>     I'm not sure that I did - possibly around a couple of

>     thousand, like one partition per day for 7 years of

>     data, and then be careful about the number of  (local)

>     indexes.

I think it was during your partition testing. Got a bell going in my mind about that.
I think the OP wants to eliminate the
need for indexing via partitioning, that would stop bugs with local indexes
from showing up? Received on Sun Apr 20 2008 - 08:35:31 CDT