intentionally introducing redundancy in database design to improve read performance and reduce joins

“Storing total order amount directly in orders table instead of calculating from items each time”