The most prevalent denormalization techniques are:
Adding redundant columns
Adding derived columns
Collapsing tables
In addition, you can duplicate or split tables to improve performance. While these are not denormalization techniques, they achieve the same purposes and require the same safeguards.
