Hello,

Could you please spell out why it is or is not a good idea to base a primary key on anything that is meaningful?

Many base primary keys off sequences, others a derivitive of something unique out of partial information of something meaningful (like <location>0001, or <asset_type>0001 etc).

What would you use for a primary key value sequence and why?

Thanks,

Effie


Oracle LazyDBA home page