O'Reilly logo

Tera-Tom on Teradata Physical Implementation V12-V13 by Tera-Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10 – Denormalization

“Most databases denormalize because they have to, but Teradata denormalizes because it wants to.”

Tera-Tom Coffing - CEO Coffing DW

Denormalization is the process of implementing methods to improve SQL query performance. The biggest keys to consider when deciding to denormalize a table are PERFORMANCE and VOLATILTITY. Will performance improve significantly and does the volatility factor make Denormalization worthwhile?

Improved performance is an admirable goal, however, one must be aware of the hazards of Denormalization. Denormalization will always reduce the amount of flexibility that you have with your data and can also complicate the development effort. In addition, it will also increase the risk for data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required