>>I have a system where new records are being added to tables
>>and receive sequential ID numbers which are the primary
>>keys. Is there a difference between using numeric and
>>integer types for these fields?
>
>Check me on this but would not integer type for key fields be faster
>than any other type...
>Just my two cents...

In addition to speed, Integers take up less space and are virtually limitless as far as the maximum number of records that can be supported (the range for type Integer is over 4 billion) so you don't get caught with a primary key too small etc.

-Doug-