Thread: Joins and field types

Joins and field types

From
Zak McGregor
Date:
Hi all

What sort of performance penalty on joins using varchar(n) vs. int fields can I expect if both tables are fairly small
(ieunlikely to have more than 20000 rows each)? 

Is there a good reference or two on these sorts of questions?

thanks a lot

Ciao

Zak McGregor