Home » SQL & PL/SQL » SQL & PL/SQL » how upadte statement works
how upadte statement works [message #242354] Fri, 01 June 2007 11:41 Go to next message
kidoos
Messages: 11
Registered: June 2007
Junior Member

i have an update statement like ,say,

update t1 set f1='e' ,f2=2 where
pk_f3 = 100;

how does oracle parse/execute this statement internally.


also if i have a function attached in the predicate

update t1 set f1='e' ,f2=2 where
pk_f3 = to_number('100');

how will the performance change ?
Re: how upadte statement works [message #242365 is a reply to message #242354] Fri, 01 June 2007 12:27 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ It parses it well
2/ Why not just making the test? And should I have to say that applying a function is longer than doing nothing?

Regards
Michel
Previous Topic: rowid mystry
Next Topic: ALTER TABLE and MODIFY COLUMN
Goto Forum:
  


Current Time: Sat Dec 10 20:30:24 CST 2016

Total time taken to generate the page: 0.07506 seconds