Mark D Powell wrote:
> The most import consideration for tuning a join is knowing what columns
> are used in the join and filter conditions, if these columns are
> indexed, what the indexes look like, and the relative size of the
> tables.
>
> You did not provide any of that information nor did you post the
> explain plan to show how Oracle is currently solving the query.
>
> So without useful information to work with I am going to guess that
> your union all view should be rewritten as a three table join where
> table2 and table3 are outer joined to table1.
>
> HTH -- Mark D Powell --
And, in addition, provide an explain plan.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Sep 01 2005 - 10:16:48 CDT
