Posted by Roy Harvey on 07/11/06 19:19

I would expect bigint to be a slightly better choice than decimal. It
stores in 8 bytes, while a decimal of 10-19 digits takes up 9.

Roy Harvey
Beacon Falls, CT

On 11 Jul 2006 12:12:27 -0700, "rottytooth" <rottytooth@gmail.com>
wrote:

>Is there any disadvantages of using Decimal type as a primary key? If
>so, are there other data types that can hold large numbers (more than
>an int can hold: 13 digits or so) and perform better as a Key field?
>
>Thanks.

[Back to original message]