Archives of the TeradataForum
Message Posted: Thu, 28 Jul 2005 @ 09:42:47 GMT
| Subj: | | Re: Rounding in TERADATA and performance |
| |
| From: | | Victor Sokovin |
| | What is the most preferable way of rounding - using direct rounding with functions like CAST ? Or is there a better way from performance
stand point ? | |
As far as I know there are only two possibilities: implicit rounding and explicit CAST. Unlike some other vendors, Teradata does not seem to
offer built-in rounding functions.
It is often difficult to compare performance between implicit and explicit casting because if you need to customize your rounding rules you
wouldn't be able to use the implicit casts.
It might be worth paying attention at where exactly you need the rounding. For example, if you sum up a couple of million values, it makes a
huge difference whether you need to round up all those values or you just need to round up the sum. But it is not only performance which matters
here but the results themselves would be quite different. Usually business rules do not leave much flexibility for rounding rules.
All in all, I don't think one can do much in this are apart from avoiding unnecessary rounding, being as economical as possible with it
etc.
Regards,
Victor
| 
