Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
tomnipotent
on May 25, 2023
|
parent
|
context
|
favorite
| on:
Cases where full scans are better than indexes
An FK also adds the burden of keeping a copy of each related row during the lifespan of a transaction. This means small-but-frequently-updated tables that are joined to a lot can be a source of unexpected headaches.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search: