Re: Tainted query ehlp

astalavista wrote:
> Hi,
>
> Is possible to optimize the tainted query below ?
>
> (explain plan at bottom)
>
> Thanks for your help (10.2.0.3)
> Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop
>
> SELECT STATEMENT Optimizer Mode=ALL_ROWS 1 6719
> SORT AGGREGATE 1
> VIEW 1 6719
> INTERSECTION
> TABLE ACCESS BY USER ROWID CDDCL318886012UID_P0U_DIFF.T_TREAT_DIFF 1
> 196 1
> SORT UNIQUE 140 K 24 M 6717
> TABLE ACCESS FULL CDDCL318886012UID_P0U_DIFF.T_TREAT_SAVE 140 K 24
> M 1023

This is not an explain plan. It is the output from some hand-crafted script.

Please repost using DBMS_XPLAN.DISPLAY. If you don't know how follow this link:
http://www.psoug.org/reference/dbms_xplan.html

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org