Comment Re:OK (Score 2) 297
The problem is, that in the real world, normalisation is hard. Third normal form is usually pretty good, except in some cases where you would have so many different tables for small relations that it's easy to get performance issues.
So, de-normalise a bit, make the query more simple, gain some performance. Great.... except, then later on, you have a different use case for the same data and that de-normalisation has just made the new statements more complex than it should be to get rid of the extra data in the result set.
This is just looking from the perspective of relational theory, and not the tool to extract the data (SQL).