 |
 |
Archives of the TeradataForum
Message Posted: Wed, 14 Oct 2009 @ 12:01:34 GMT
| Subj: | | Re: Integer data types vs. Decimal(n,0) - which is better? |
| |
| From: | | Boris Mogilevsky |
Dieter, thanks for the explanation, though the last part is not very clear to me.
| | Maybe this is from V2R1 when there was no BIGINT yet. An integer might easily run out of number when the default batch value of 100.000 is
used: | |
| | 2000 AMPs * 100.000 = 200.000.000 | |
| | After 10 restarts it hits the limit. | |
| | So the actual decision is just BIGINT vs. DEC(18,0). Which one to choose, see above. | |
Thanks,
Boris Mogilevsky,
Teradata Consultant
| |
