In article <76sgs3$hvu$1_at_nnrp1.dejanews.com>, cutler_temp_at_usa.net writes
>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.
>
8 is nothing like 7 in this respect...
Steve
--
Please remove nospam from my address to Reply.
Received on Tue Jan 05 1999 - 12:56:07 CST
