---
title: "What is denormalization and when would you go for it?"  
description: "What is denormalization and when would you go for it?"  
author: "Anonymous User"  
published: 2011-05-20  
updated: 2020-09-24  
canonical: https://www.mindstick.com/interview/972/what-is-denormalization-and-when-would-you-go-for-it  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What is denormalization and when would you go for it?

As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced.

## Answers

### Answer by Anonymous User

As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced.


---

Original Source: https://www.mindstick.com/interview/972/what-is-denormalization-and-when-would-you-go-for-it

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.