Archives of the TeradataForum
Message Posted: Tue, 22 Apr 2003 @ 17:04:17 GMT
You may be correct that it might rewrite the data row for this alter since truncation of the whole number will occur from 13 digits to only 12.
I did not pay close attention to the scale shrinking...I only noticed the 15 going to 18, without accounting for the number of digits to the right of the decimal.
Many times I have done an alter table to go from a smaller number, say DECIMAL(7,2) to a larger number, DECIMAL(10,2) and the change was instantaneous, as in one second response in QueryMan (even on tables loaded with 100 million+ rows)!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|