What are the advantages and disadvantages of Normalization?
There are several advantages of normalization as under: * Faster sorting and index creation. * A larger number of clustered indexes. * Narrower and more compact indexes. * Fewer indexes per table, which improves the performance of INSERT, UPDATE, and DELETE statements * Fewer null values and less opportunity for inconsistency, which increase database compactness. Beside the above benefits there are few disadvantages as well: * Increased amount of Normalization increases the amount of complexity of joins between tables and that hinders the performance.
