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

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.