Is it necessary to materialize a view ? This defeats the normalization principal for redundant data. Why do designers ignore this rule !! | SoloLearn: Learn to code for FREE!

+1

Is it necessary to materialize a view ? This defeats the normalization principal for redundant data. Why do designers ignore this rule !!

sql

7/19/2016 8:33:12 AM

Ashutosh Singh

1 Answer

New Answer

0

There could be valid reasons to do this: performance, or audit requirements to freeze the dataset to have a record how the data looked at some point.