Q 11. What is Denormalization?
Ans : Denormalization is a database optimization technique in which we add redundant data to one or more tables. This can help us avoid costly joins in a relational database.
Note that denormalization does not mean not doing normalization. It is an optimization technique that is applied after normalization.
In a traditional normalized database, we store data in separate logical tables and attempt to minimize redundant data. We may strive to have only one copy of each piece of data in the database.
No comments:
Post a Comment