Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Papers on Partition Elimination?

Re: Papers on Partition Elimination?

From: <cutler_temp_at_usa.net>
Date: Tue, 05 Jan 1999 08:01:08 GMT
Message-ID: <76sgs3$hvu$1@nnrp1.dejanews.com>


I'm speaking from experience using 7.3.x partition views, which are not nearly as clean as 8.0.x partitioning (not that 8.0 is clean!). There are quite a few requirements to make this all work. See the Oracle 8.0.x on-line documentation, under Server Concepts, Chapter 8: Partitioned Tables and Indexes, and Server Tunining, Partitions: http://www.eng2.uconn.edu/~orasun/doc/server803/index.htm

If 8 partitioned tables are anything like 7.3.4 partition views, in order for partition elimination to work, your tables have to be analyzed. Your query may have to have the value hard-coded (rather than using bind variables) to restrict the partitioned column to a subset of the partitions. Even then, you have to look at the explain plan to really know if it's all working correctly.

In article <75mrtj$60r$1_at_nnrp1.dejanews.com>,   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 Jan 05 1999 - 02:01:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US