Ravindra BagaleCourses & study guides मराठी Track your progress

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.

One table or many?: Single-table vs Multi-table
One table or many? · Download PNG
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.

See all AWS revision cards