Re: A question about UPDATE. How smart is oracle

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 17 May 2005 00:14:27 +0200
Message-ID: <7m6i811dcc4bq29lb6phphhq7ktu41vde4@4ax.com>

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 DBA

Received on Mon May 16 2005 - 17:14:27 CDT