|
|
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.
Navigation:
[Reply to this message]
|