Table ID Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Gene S. (anonymous_at_discussions.microsoft.com)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 15:11:17 -0700

Hello,

I have a question regarding table ids I'm hoping someone
can help me with. I have a table where I can use either
the tinyint or a char(1) datatype for my table id(pk) due
to the table having a small number of records. Both are
stored as 1byte so is there a performance advantage to
using one as opposed to the other?

Any help would be greatly appreciated!
Thanks in advance