Saturday 24 July 2010

dumb question – PK vs. unique index

Why does JDE have primary keys defined with the same columns as unique indexes?  I do not get it.  I’d guess that they take up the same space.  The DB is not going to allow the unique index to be “violated”, so why have the PK as well.  Can anyone tell me?

No comments: