Normalization effects performance?
Solved
CS614 - Data Warehousing
-
-
True
-
False
-
-
Full normalisation will generally not improve performance, in fact it can often make it worse but it will keep your data duplicate free. In fact in some special cases I’ve denormalised some specific data in order to get a performance increase. Normalization comes from the mathematical concept of being “normal.”
Source