News for hackers. Stuff that matters.

A comment on Ask HN: How do I represent a hierarchy in RDBMS?. Parent comment

Re:Ask HN: How do I represent a hierarchy in RDBMS? by dragonwriter on Wednesday May 29, 2019 @05:38PM (#20045814)
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.

[ Parent | on HN ]

There are no comments on this comment yet.