What is De-Normalization?
It is a process of attempting to optimize the performance of a database by adding redundant data. Redundancy is introduced intentionally in a table to improve performance, and it is called de-normalization. The de-Normalization process enhances the read performance while some degradation occurs in write performance. It can be achieved by making a group of data in the redundant form. The un-normalized and de-Normalized database are completely different from each other. Before the process of de-normalization of any database, that should be normalized firstly.
