Report question

Question: How costly are JOINs in SQL? And/or, what's the trade off between performance and normalization?