<|im_start|>user
What are the pros and cons of denormalizing data sets?<|im_end|>
<|im_start|>assistant
The pro for denormalizing data is to optimize for scan related queries of data and data serving. The con is that denormalization increases data latency due to the re-building of the materialized view.<|im_end|>
