Re: Do Sequences Have Any Disadvantages?

Just be carefull to put a "no-cache" option on a sequence. The default is to cache sequences. So when the instance is started it will cache a certain number from your sequences. This makes selects from it faster, but when ever the server goes down (either from shut-down or crash) you loose that set of numbers.

John Jones
Oracle Consultant
jmj22026_at_glaxowellcome.com Received on Thu Feb 13 1997 - 00:00:00 CST