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
Printable View
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
Small int. It'll consume less space (I think it's 2 bytes) than than char fld. Less space almost always = faster.