Re: Optimizer not pushing filters down into view

From: <mccmx_at_hotmail.com>
Date: 23 Aug 2006 03:13:10 -0700
Message-ID: <1156327990.047337.101280@m73g2000cwd.googlegroups.com>

> General clues:
>
> Note also that that view is defined with an ANSI
> join, and there are bugs in ANSI transformations -
> so it is possible that you have hit a problem as
> Oracle implemented a PARTITION VIEW approach
> to your query (see UNION ALL PARTIION - line 4
> of the second plan), and then failed to handle the ANSI
> view inside one half of the UNION ALL.
>
>

Interesting point. Because when I run the exact same SQL against the same data set in 9.2.0.4, the filters are pushed OK. And the plan shows UNION ALL in 9.2.0.4 where it shows UNION ALL PARTITION in 10.2.0.2.

So it may be a bug in the 10g version...!

Matt Received on Wed Aug 23 2006 - 05:13:10 CDT