Backend & systems·Data modelling and storage engines
you copy the customer's name into the orders table so the list page stops doing a join on every render.
Denormalisation
Also calleddenormalization
Deliberately duplicating data to avoid joins or aggregate computation on the read path. It is the standard fix once a hot query's join cost dominates, and it is how most read models are built. The duplicated field is now yours to keep in sync forever, so it only pays where reads vastly outnumber writes.