guid related ( repeat)

2002-07-12 Thread BigP 




hi everybody ,
oracle provides guid function to generate unique 
ids . My question is should one use that guid for synthetic primary key .So you 
no longer need a sequence for generating unique values . Is it faster to do a 
search on number comapred to varchar2 if it is indexed .
My just debating if i should use guid to for 
primary key .

-Bp

Re: guid related ( repeat)

2002-07-12 Thread Igor Neyman 



Just based on the length of the field, I'd prefer sequence 
generated unique values.

Igor Neyman, OCP DBA[EMAIL PROTECTED] 


  - Original Message - 
  From: 
  BigP 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, July 12, 2002 4:08 PM
  Subject: guid related ( repeat)
  
  
  hi everybody ,
  oracle provides guid function to generate unique 
  ids . My question is should one use that guid for synthetic primary key ..So 
  you no longer need a sequence for generating unique values . Is it faster to 
  do a search on number comapred to varchar2 if it is indexed ..
  My just debating if i should use guid to for 
  primary key .
  
  -Bp