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

From: amit poddar <amit.poddar@xxxxxxxx>
To: mseiwert@xxxxxx
Date: Thu, 27 Mar 2008 12:29:17 -0400

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 selectstatement differs completly from the execution plan of the updatestatement? While the select statement uses a very good plan using nestedloops and highly indexed access the update statement full scans thetables accessed through the view v_titel2 ? Please see attachedtextfiles for execution plans. If more information is needed I couldprovide 10046 and 10053 traces.
S



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

References:

Completly different execution plans select vs. update with same where clause
From: Michael Seiwert

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

Other related posts: