The conversation between human and AI assistant.
[|Human|] What are the pros and cons of denormalizing data sets?
[|AI|] 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.
[|Human|] 
What are the pros and cons of denormalizing data sets?