Re: sequence numbers

[Tim Gorman]

CACHE 20 is the default, so if you remove the clause, it will have absolutely no impact on performance or anything else...   ...of course, I get the feeling that that wasn't the gist of your question, was it? ----- Original Message ----- From: April Wells To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 09, 2002 8:54 AM Subject: sequence numbers I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads.  How huge is the potential performance hit if I take out the cache 20?   April Wells Oracle DBA  There is neither good nor bad, but thinking makes it so. -Shakespeare