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 -> Surrogate Key vs Production Key

Surrogate Key vs Production Key

From: xtanto <krislioe_at_gmail.com>
Date: 5 Oct 2004 22:39:00 -0700
Message-ID: <e1c9bd55.0410052139.2c139132@posting.google.com> 





Hi Gurus,



I have a transaction table having unique external document number. It
can be assured that it is unique. It is a varchar2(30).
This is a header-detail transaction.



The options is :


Whether I should use this unique external document table as PK ?
(means I have also to store this value in Detail table)
OR 


Should I create an ID based on Sequence as 'Surrogate' PK ?



What is the cost/benefit ?



Thank you for your help,


xtanto
Received on Wed Oct 06 2004 - 00:39:00 CDT












Original text of this message













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