RE: Speed (char or integer)

2001-08-07 Thread Carsten H. Pedersen
I have a table with (char)Username attribute which is the primary key of the table and also acts as a foreign key in many other tables. My question is if the queries would be faster if i used a numeric value for the primary key? Integers would be faster, but the question is really by

Re: Speed (char or integer)

2001-08-07 Thread ryc
a good deal faster. ryan - Original Message - From: Goran Krajacic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 9:33 AM Subject: Speed (char or integer) I have a table with (char)Username attribute which is the primary key of the table and also acts