Re: Papers on Partition Elimination?

Ha! I guess my post would seem a little vague to those who have no experience with Oracle8 partitioning. One of the supposedly great features about partitioning is that when you query a partitioned table and your query only requires data from one partition, that's the only partition that should be accessed. All of the other partitions unnecessary to satisfy that query are ELIMINATED.

Unfortunately, partition elimination seems to occur under very limited circumstances ... such as when the moon is green and Jupiter aligns with Mars or some such nonsense. That's what I'm trying to find out -- what criteria, or under which circumstances, is the optimizer able to eliminate partitions from access paths.

In article <367FDDD3.359F5975_at_pharma.novartis.com>,   devinder <devinder_pal.singh_at_pharma.novartis.com> wrote:
> Be a little more specific. Oracle 8's biggest feature is availability of
> partitions and you are talking about eliminating them.
>
> acedba_at_my-dejanews.com wrote:
>
> > Anybody know where I can find a technical paper explaining how
> > Oracle8 eliminates partitions?
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 22 1998 - 15:11:28 CST