"Volker Schmid" <Info_NoSpam_at_Inspirant.de> wrote in message
news:app0k8$773$1_at_news.online.de...
> Hi Alan, Dirk,
>
> What if I use:
>
> CREATE SEQUENCE USERS_SEQ START WITH 1 INCREMENT BY 1 NOCACHE;
>
> Is it then better?
Its not better for performance or scalability. Neither does it solve the
'problem' that you can lose sequence numbers. However This generally isn't
really a problem, you still have a unique meaningless primary key
autogenerated for you. Why do you want an unbroken sequence?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Oct 31 2002 - 07:28:39 CST
