As to the article you linked: I agree stability is desireable in a primary key. And most natural keys do not change often. It is just that they *can* change and that change must be able to handled. And so I'm not really that worried about nitty gritty performance considerations wrt something that happens very occasionally. And as to it being able to be handled...does Oracle really still not support UPDATE CASCADE??? (the link in the article about that is to is from a discussion in 2002...I tried looking at Oracles CREATE TABLE document page and...man there's a lot of crap on that page so I'm not sure if I'm just failing to find it there...) Without UPDATE CASCADE at my disposal I would probably feel forced to create more surrogates.
-- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
