instruction: What are the pros and cons of denormalizing data sets?
output: 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.