Performance (Primary Key)

[chicho_chicho]

Hello,
I have to make a decision between a char(9)
or a smallint on SQLServer 7 for a
Primary Key on a Products Table
Does anyone have suggestions about which performs
better?
Thanks!
Chicho

[JHausmann]

Small int. It'll consume less space (I think it's 2 bytes) than than char fld. Less space almost always = faster.