A large e-commerce website experiences slow query performance due to a massive volume of customer data. What relational schema design technique could you employ to optimize storage and enhance query performance?

  • Denormalization
  • Indexing
  • Normalization
  • Sharding
In this scenario, to enhance query performance, denormalization can be employed. Denormalization involves introducing redundancy in the database design to reduce the number of joins, leading to faster query execution. It's especially useful when dealing with read-heavy workloads and large datasets.
Add your answer
Loading...

Leave a comment

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