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 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
