Yeah, that's a good one. I have found, however, that denormalized tables designed for the queries that you need to do can make a massive impact on performance,

Yeah, that's a good one. I have found, however, that denormalized tables designed for the queries that you need to do can make a massive impact on performance, especially at scale. However, it's also a massive pain in the Automated System Structure to keep them updated properly.