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


Michael Seiwert wrote:

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.



Other related posts: