Adding redundant data to one or more tables is a database optimization technique called denormalization. This can assist us in avoiding relational database joins that are expensive. Be aware that denormalization does not equate to “not normalizing” or “reversing normalization.” It is an optimization method used subsequent to normalization.
Vishalini.R Answered question
