In a situation where data normalization is causing performance issues, what SQL technique could be used to balance normalization with query efficiency?

  • Denormalization
  • Indexing
  • Partitioning
  • Subquery
In situations where data normalization impacts performance, denormalization can be used. Denormalization involves introducing redundancy into the database by storing redundant data, which can reduce the need for complex joins and improve query efficiency. It's a trade-off between normalization and performance.
Add your answer
Loading...

Leave a comment

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