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 -> Type of surogate primary key

Type of surogate primary key

From: Dan G <Gavrilescu.Daniel_at_pmintl.ch>
Date: Tue, 4 Jan 2000 10:46:25 +0200
Message-ID: <84sbn6$k6a$1@pollux.ip-plus.net> 





Hello all,



and a HNY in 2000.



I've taken a design decision to use for all my database tables surrogate
primary key. I don't want to argue about this (there are pros and cons).
The question is:


Which is the best type for the surrogate key  (pure) numeric or alphanumeric
?.


Any pros and cons will be appreciated (index consideration, space
allocation, programming any drawbacks.



Thanks,


Daniel.


Received on Tue Jan 04 2000 - 02:46:25 CST












Original text of this message













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