Re: Left outer join

On Thu, 13 Nov 2003 22:53:39 +0100, "Erik" <no_at_spam.com> wrote:

>> Predicate Information (identified by operation id):
>> ---------------------------------------------------
>>
>> 1 - filter("CC"."ATT"='C1')
>> 5 - access("AC"."ACCOUNT"="CC"."ACCOUNT"(+))
>
>How do I do to see this information?

 Provided you have Oracle 9.2, look up DBMS_XPLAN, and when you create your PLAN_TABLE make sure you use the latest version of the table definition, from $ORACLE_HOME/rdbms/admin/utlxplan.sql.

 Do an explain plan as normal "explain plan for select * from wherever", then do "select * from table(dbms_xplan.display())".

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)