Re: Completly different execution plans select vs. update with same where clause

Is it possible to get the ddls for all the corresponding objects

amit

Michael Seiwert wrote:
> Hi,
>
> could anybody explain to me why the execution plan of the select
> statement differs completly from the execution plan of the update
> statement? While the select statement uses a very good plan using nested
> loops and highly indexed access the update statement full scans the
> tables accessed through the view v_titel2 ? Please see attached
> textfiles for execution plans. If more information is needed I could
> provide 10046 and 10053 traces.
>
> S
>
>
>

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