T-SQL

What is Denormalization?

This is simply the process of combining smaller tables to make larger tables. This can be used to address problems with performance or scalability.

This is usually caused by tables being stored in separate files on disks and when databases are being queried   there is a requirement for each several files to be accessed according to the joins thus slowing the query down.

Leave a Reply