the reason you are using joins, most often is because your schema is normalized. One way or another, de-normalisation + queries will cost you more, than normalised tables and joins. That's at least the short answer.
- [GENERAL] The REAL cost of joins Marcin Krol
- Re: [GENERAL] The REAL cost of joins Peter Hunsberger
- Re: [GENERAL] The REAL cost of joins Richard Huxton
- Re: [GENERAL] The REAL cost of joins Grzegorz Jaśkiewicz
- Re: [GENERAL] The REAL cost of joins Craig Ringer
- Re: [GENERAL] The REAL cost of joins Merlin Moncure
- Re: [GENERAL] The REAL cost of joins Simon Riggs