Technical Discussion :: SQL
Home > Freshers > Technical Interview Questions > SQL
71. What are the advantages and disadvantages of Normalization?
Answer:
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.
Asked In :: Syntel Inc.
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.
* 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.