Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: A question about UPDATE. How smart is oracle
On 16 May 2005 12:04:22 -0700, ohahaahr_at_hotmail.com (Ole Hansen)
wrote:
>I have made 2 statements, shown below. Which one should i use ?
Oracle isn't smart enough to skip redundant updates. However, your additional where clause in statement 2 to avoid those, add so much inefficiency to the statement, that statement 2 would use way more resources than statement 1, so your attempt to play smart on behalf of Oracle will hit you back in the face.
-- Sybrand Bakker, Senior Oracle DBAReceived on Mon May 16 2005 - 17:14:27 CDT
![]() |
![]() |