This discussion is archived
2 Replies Latest reply: Dec 8, 2013 10:13 PM by 956118 RSS

explain plan for update

956118 Newbie
Currently Being Moderated

Hi

 

I am new to the sql tuning.

 

When I wrote this below query  and generate the explain plan ,It is showing following 3 steps .

 

1.very row in table employees is read .

2.Rows were updated.

3.Rows were updated.

 

Why the oracle is doing the update operation 2 times?Why it is showing 3 stesp where as I ma expecting only 2 steps something like below .

1.very row in table employees is read .

2.Rows were updated.

 

update employees

set salary = 2300

 

 

thanks

sri

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points