Denormalization

What is Denormalization?

Denormalization is the process of combining normalized tables to reduce join operations and improve read performance.

When to Use:

• Reporting or analytics
• Minimize complex joins
• Read-heavy systems

Example:

Adding department name directly to the employee table instead of joining from departments table.