SQL Server Functions Question:

Download Job Interview Questions and Answers PDF

What is De-normalization?

MS SQL Server Functions Interview Question
MS SQL Server Functions Interview Question

Answer:

The process of adding redundant data to get rid of complex join, in order to optimize database performance. This is done to speed up database access by moving from higher to lower form of normalization.

Download MS SQL Server Functions Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Steps of normalization?What do you know about Normalization and De- Normalization?