Back to course home
0% completed
Vote For New Content
Shouldn't SQL normalization increase read complexity?
Mohit
Jul 14, 2024
Under the Key Differences section, it says:
Normalization increases the complexity of the write operations.
However I thought it would increase the read complexity since now we have to do a join to get the same data.
4
0
Comments
Comments
B
bauyrzhan.a.tokenov a year ago
I thought the same, must be a mistake.
Design Gurusa year ago
That is right. Normalization makes writes faster but reads slower whereas denormalization makes writes slower but reads faster.
We have updated the lesson with an example.
On this page