Hacker News new | ask | show | jobs
by dragonwriter 2576 days ago
The pros are you aren't creating unnecessary sequences and tables, which has both storage space and join complexity savings.

The cons are...none, really; the extra surrogate keys aren't buying you anything.