When might you denormalise?
Model answer
When reads are far more common than writes and joins are too slow, you may store a copy of a value (such as a count or a name) in another table. This speeds reads but you must keep copies in sync, so do it deliberately after measuring.
Learn this topic
Keys and Table Design: Why Data Is Split Into Tables in the course SQL for Beginners: Learn Databases Step by Step.
Sign in to add your own answer.