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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.