---
title: "What is Denormalization?"  
description: "What is Denormalization?"  
author: "Shikhar Arora"  
published: 2019-12-06  
canonical: https://answers.mindstick.com/qa/92520/what-is-denormalization  
category: "database"  
tags: ["database programming", "database"]  
reading_time: 1 minute  

---

# What is Denormalization? 

What is [Denormalization](https://www.mindstick.com/articles/437/denormalization-in-sql-server)

## Answers

### Answer by Rahul Roi

![What is Denormalization?](https://answers.mindstick.com/questionanswer/6ac95c76-d1ba-434c-861e-2bac20db85ae/images/6913e1a1-25b8-46f9-b95f-53e982e14d3d.jpeg)\

## If we talk About the Denormalization, it is a database optimization technique in which we add redundant data to one or more tables. It can help us avoid costly joins in a relational database. Attention that denormalization does not mean not doing normalization. This is an optimization technique that is applied after doing normalization. \
Via a traditional normalized database, we store data in separate logical tables and attempt to minimize redundant data. We can try to keep only one copy of each piece of data in the database. \
For instance, in a normalized [database](https://www.mindstick.com/forum/145506/what-is-deadlock-condition-in-dbms), we might have a Courses table and a Teachers table.Each entry in Courses would store the teacherID for a Course but not the teacherName. If we need to retrieve a list of all Courses with the Teacher name, we would do a join between these two tables.

![What is Denormalization?](https://answers.mindstick.com/questionanswer/6ac95c76-d1ba-434c-861e-2bac20db85ae/images/11dd540d-3357-4d07-838a-0c114e769f80.jpeg)\


---

Original Source: https://answers.mindstick.com/qa/92520/what-is-denormalization

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