What are the pros and cons of denormalizing data sets?
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.
Below is an instruction that describes a task, paired with an input that provides further context. Write a response that appropriately completes the request.
### Instruction: What are the pros and cons of denormalizing data sets?
### Input: 
### Response: 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.