Interview Q&A / SQL & DBMS

1. What is denormalization and when would you use it?

   Denormalization deliberately adds redundant data, such as copied columns or precomputed totals, to avoid joins and speed up reads. It trades storage and write complexity for read performance, and suits read-heavy reporting.

   IntermediateQuick answer1 min read