FWIW if you have the choice I’d never use a compou...

# squarelibraries

[Robert Menke]

FWIW if you have the choice I’d never use a compound primary key. You can have a compound unique index and it just makes life easier to have a single primary key. Also easier for the engine to optimize for.