What are the pros and cons of denormalizing data sets?
Below is an instruction that describes a task. Write a response that appropriately completes the request.

### Instruction:
What are the pros and cons of denormalizing data sets?

### 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.