3 ms·
As others mentioned, normalization is generally about saving space not increasing performance. That said I’m 100% positive that all those key value pairs are i
by rco8786 7y ago
As others mentioned, normalization is generally about saving space not increasing performance.
That said I’m 100% positive that all those key value pairs are indexed for searching and querying purposes.
- rodgerd 7y agoIt's also about DRY and accurately modelling the data for general operations. Imagine the difference between a data environment where a GDPR deletion request comes in, and everything has a relation back to customer identity, and one where the customer identity is denormalised out to many places or only implicitly present.
- RhodesianHunter 7y agoNot so much indexed, just columnar.