Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Outer Join reads all rows from underlying tables
Matt,
You said that the best filter is on TM_DATE column.
You did not say that which table or view the TM_DATE column is coming
from in the view ps_rr_flat_vw. Is it the tm_eff_start_date column in
the view ps_tm_peff_v_cc_vw (which in turn comes from
PS_TM_PEFF_CONTRIB table).
I dont see how this filter applies to the tables in PS_TM_PEFF_V_CCEH.
In your plan i see this TABLE ACCESS BY INDEX ROWID PS_TM_PEFF_GPQ,
but in none of your view definitions, i see the table PS_TM_PEFF_GPQ.
regards
Srivenu
Received on Fri May 14 2004 - 06:07:08 CDT
![]() |
![]() |