You are here

Denormalize

This is the process of converting normalized tables again into a de-normalized form. Here, a table may contain redundant information. This is a common technique within data warehousing where star schemas are used to optimize performance.


Denormalizing a database consumes more
space and slows OLTP performance but improves query performance in a BI
environment.