Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Indexed Organized Tables

Re: Indexed Organized Tables

From: Hans Erik Busk <tbf_at_cn.stam.dk>
Date: Mon, 10 Jan 2005 21:39:55 +0100
Message-ID: <2up5u097i1anql972c0kbkc061rqdbl671@4ax.com> 





On 10 Jan 2005 11:04:20 -0800, bdbafh_at_gmail.com wrote:



>use a sequence to generate a numeric unique identifier and add that

>column to the primary key - populate in the insert trigger if the

>sequence.nextval is not included in the insert statement.




And if performance should be a problem increase the sequence's cache
size.



H.E. Busk


Denmark
Received on Mon Jan 10 2005 - 14:39:55 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US