By default, decimal data is imported into Double format to speed up calculations. Double types can execute up to 5 times faster than Decimal. This may cause rounding issues when dealing with large amount of records.
To disable this behavior, use the command
SET PRESERVE DECIMAL TRUE
To re-enable Decimal to Double conversion, use
SET PRESERVE DECIMAL FALSE
Please sign in to leave a comment.