Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
m33k44
on May 29, 2019
|
parent
|
context
|
favorite
| on:
Ask HN: How do I represent a hierarchy in RDBMS?
What are the pros and cons of this approach?
dragonwriter
on May 29, 2019
[–]
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.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
