A small Int occupies twice less storage space than an Integer occupies. So, i'm thinking of converting a Integer column of 4 bytes in length to a Small Integer type. Is there any way to alter the data-type from Integer to SmallInt in DB2? If yes, will there be a considerable savings as I'm thinking?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need to convert Integer to SmallInt
- Thread starter jafsaqusa
- Start date
- Status