Re: 11gr2 sql issue

From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Wed, 9 Nov 2011 13:17:49 +0800
Message-ID: <CAM_ddu8r8-c5rn85wP6riw5-ktKR-0spbPZUi4O+GC8KgdYYwg_at_mail.gmail.com>

Kumar,
attachment will be filtered in the list.

please show the execution plan in both version

explain plan for
<your sql>;
select * from table(dbms_xplan.display(null,null,'typical'));

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 08 2011 - 23:17:49 CST