You can use various methods to denormalize a database table and achieve desired performance goals. Some of the useful techniques used for denormalization include the following:
Keeping redundant data and summary data
Using virtual columns
Performing horizontal data partitioning using multiple tables rather than table partitioning
Performing vertical data partitioning
From an I/O standpoint, joins ...