Re: data modeling question.. too many joins?

On Mon, 09 Sep 2002, eugene1977_at_hotmail.com wrote:

> if i want to find out scores of games that my school played..
> i had to join each table twice..
>
> since i heard join is expensive process, i 'm wondering if it's better
> to have school name in teams table(duplication of data) for faster
> data retrieval..

For the data you are talking about, "to join or not to join" isn't a question.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.