Y
Hacker News
new
|
ask
|
show
|
jobs
by
m33k44
2577 days ago
What are the pros and cons of this approach?
1 comments
dragonwriter
2577 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.
link
The cons are...none, really; the extra surrogate keys aren't buying you anything.