I think we are all familiar with database normalization.
My question is: What are some guidelines that you use when you want to denormalize the tables?
database-design
I think we are all familiar with database normalization.
My question is: What are some guidelines that you use when you want to denormalize the tables?
Best Answer
Denormalize when it's OLAP operations, normalize when OLTP (from linked article under section Denormalization)