Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Papers on Partition Elimination?
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
![]() |
![]() |