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 -> One sequence or not?

One sequence or not?

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 05 Nov 2002 19:06:16 GMT
Message-ID: <IEUx9.63856$X9.22712785@twister.socal.rr.com> 





I'm working on a project where they've used ONE Oracle sequence to
generate surrogate keys for all rows in all tables.  This database will
be used for ad hoc queries and reports.  Since an ID will only appear in
one table, the reasoning is that any incorrect joins will result in no
data being returned rather than incorrect data.  



Opinions?  Experiences?




Thanks,


Richard Kuhler
Received on Tue Nov 05 2002 - 13:06:16 CST












Original text of this message













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