The tables for which I am responsible are defined with a generated identity-pk and most of them in Decimal(18) format.
What would you recommend, is better to use?
I suppose BigInt is similar to COBOL-Binary and Decimal is similar to COBOL-Display?
Than I guess BigInt requires much less storage space in table- and in indexspace as well.
Furthermore, I suspect that it's faster to compute new BigInt- than Decimal identities - similar to COBOL - because decimal values need to be converted in binary format.
Am I right? Do you agree with that?
Thanks a lot for your help