Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Why Oracle don't have AUTO_INCREMENT as in MySQL
On Wed, 25 Apr 2007, damorgan_at_psoug.org wrote:
> Galen Boyer wrote:
>> On Mon, 23 Apr 2007, damorgan_at_psoug.org wrote: >> >>> I think Oracle is remarkably easy to use given its power. >> And so do I. We are talking about a particular feature of the >> Oracle >> engine. Not the entire engine. The sequence is not as easy to >> implement than an autoincremeting datatype, plain and simple.
Yet another disingenuous statement. In many situations BULK COLLECT and FORALL allow for far superior performance gains over cursor loops, so it behooves one to learn whatever they should learn to get the better performance benefits.
The scenario we are discussing in this thread, on the other hand, have no measurable diffence in performance. The only measurable parameter is maintainability of code.
-- Galen BoyerReceived on Thu Apr 26 2007 - 22:12:01 CDT