Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table Design!
Yes this is a basic property of an oracle sequence.
ORDER can be a scalability killer in using sequences in a high volume environment.
It appears as if you are making assumptions about the business requirements of an application that is using sequences, well beyond any question posed by either the OP or by other people in this thread.
Many people use sequences only to generate a system generated unique identifier.
If an application needs a date or timestamp and you are trying to force that by assuming an ORDERed sequence, I would advise you to reconsider that part of the design. Received on Tue Nov 15 2005 - 14:14:01 CST