How does denormalization in database schema design affect data redundancy and read performance?

  • Decreases data redundancy and improves read performance
  • Increases data redundancy and improves read performance
  • Decreases data redundancy and decreases read performance
  • Increases data redundancy and decreases read performance
Denormalization in database schema design increases data redundancy but can improve read performance. By storing redundant data, queries can often be faster since they require fewer joins. However, this comes at the cost of increased storage requirements and potential data update anomalies.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *