Ravi Sir's Cards › AWS
One table or many?
This comparison card contrasts One table or many. Single-table is described as many entities, overloaded keys, fewer joins. Multi-table is described as separate tables per domain/lifecycle. The card pairs Single-table with default start, and Multi-table with when indexes hurt.
Read card text
What this card says
One table or many?
Single-table
Many entities, overloaded keys, fewer joins.
Multi-table
Separate tables per domain/lifecycle.
Key points
Most serverless apps with related entities.
Strong isolation or huge indexes.
Example
PK prefixes + GSIs
Use when
Default start.
When indexes hurt.