Re: Pro*C Question
From: Paul722532 <paul722532_at_aol.com>
Date: 9 Apr 1999 20:20:17 GMT
Message-ID: <19990409162017.00748.00000735_at_ng12.aol.com>
Date: 9 Apr 1999 20:20:17 GMT
Message-ID: <19990409162017.00748.00000735_at_ng12.aol.com>
They are not equal in performance.
2 is a for loop within C and so the UPDATE statement will be executed number times.
1 is a single UPDATE statement that Oracle handles at once. The FOR clause effectively tells Oracle how many rows it is to handle.
The single UPDATE is the correct way and the fastest.
Cheers,
Paul Received on Fri Apr 09 1999 - 22:20:17 CEST