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
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

Reply via email to