vandy899 wrote:

>>
>>I'm wondering if there's an associated performance penalty for using
>>BIGINT as opposed to INTEGER for primary/surrogate keys.
>
>
> I don't know, but I honestly don't think it would be that great. Even
> if 64-bit ints were not platform native, it would only be half the
> speed at comparing the keys, a small part of the join stuff (Query
> Planner is more expensive).

Firebird supports two types of numeric indexes, int64 and double. All
numeric keys are converted to one or the other.

regards,

Ann