2 ms·
Normalization/denormalization is like creating/dropping indexes - it changes physical data layout without changing data model. Either one of the four can and d
by DenisM 18y ago
Normalization/denormalization is like creating/dropping indexes - it changes physical data layout without changing data model.
Either one of the four can and does in some circumstances increase or hinder performance.
For exmample: if you drop all indexes, queries that depend on it become slow. If you create an index on every column it will take longer for optimizer to consider all possible strategies, and it will take longer to maintain indexes.
If you copletely denormalize your data you may see increased read performance since there will be less need to do joins. Or you may see decreased read performance because now your data tkaes more space on disk and you do more IO.
So, yes normalization/denormalizarion is a valid performance optimization technique. It also happens to carry with it the risk of violating data integrity which must be guarded against.