joining on varchars is always going to be very expensive. Longer thevalue is, more expensive it will be. Consider going for surrogatekeys.