Pruning was always working for me though. You can share your setup if you
like so we can take a look at it.
On 8/23/07, Elliott, Patrick <patrick.elliott_at_medtronic.com> wrote:
>
> Partitioned views are the way to go if you have a check constraint in
> place for each union all, and IF the optimizer works as it is supposed to.
> When I worked with them, I could never get the pruning to work as it was
> supposed too. YMMV
>
>
> Pat
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Suresh Chaganti
> *Sent:* Thursday, August 23, 2007 12:55 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* partitioned Views - Union All
>
>
>
>
>
--
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf/
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 23 2007 - 14:41:30 CDT
