Denormalization

SQL - Denormalization When and Why

• Denormalization trades storage space and write complexity for read performance—use it when query performance bottlenecks are proven, not assumed