3 ms·
NUMERIC (without a precision or scale) is a variable-length datatype, and suffers all the performance problems mentioned above. If you specify a precision and
by tatersolid 9y ago
NUMERIC (without a precision or scale) is a variable-length datatype, and suffers all the performance problems mentioned above.
If you specify a precision and scale, performance of NUMERIC improves quite a bit, but now you can’t store values with vastly different magnitudes (USD and JPY) in the same column without wasting tons of storage on each row. You’re back to square one.