Benefits of Normalization
Following are the major advantages of normalization:
• Because information is logically kept together, normalization provides improved overall understanding of the system.
• Because of controlled redundancy of data, normalization can result in fast table scans and searches (because less physical data has to be processed).
• Because tables are smaller with normalization, index creation and data sorts are much faster.
• With less redundant data, it is easier to maintain referential integrity for the system.
• Normalization results in narrower tables. Because you can store more rows per page, more rows can be read and cached for each I/O performed on the table. This results in better I/O performance.
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
