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.