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

From: amit poddar <>
Date: Thu, 27 Mar 2008 12:29:17 -0400
Message-ID: <>

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


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

Received on Thu Mar 27 2008 - 11:29:17 CDT

Original text of this message