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.