Denormalizing a Database
Denormalization is the process of taking a normalized database and modifying table structures to allow controlled redundancy for increased database performance. Why would you want to denormalize a database? The only reason to ever denormalize a database is to improve performance. A denormalized database is different than a database that has not been normalized.
Denormalizing a database is the process of taking the level of normalization within the database down a notch or two. Remember, normalization may actually slow performance since table join operations will frequently occur. Denormalization may involve recombining separate tables, or creating duplicate data within tables in order to reduce the number of tables that ...
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
