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
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: 65155
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?

Previous Topic: Need to Tune this query
Next Topic: Need help w/ cursors
Goto Forum:

Current Time: Thu Aug 24 05:41:31 CDT 2017

Total time taken to generate the page: 0.07042 seconds