I need to add new field to a table. The field will only store a number that ranges from 0 to maybe 30, so (in theory) a single byte field should be fine.
The smallest integer data-type listed in the documentation is SMALLINT which requires 2 bytes.
The table I want to add the field to is partitioned and currently holds approximately 3 billion rows. So adding a 2 byte field to each row should require 6 billion bytes, or 6 GB.
For reasons I still haven't fathomed, (see this question) I'm running out of space when adding a SMALLINT field to a large table.
QUESTION - is there a single-byte datatype I can use to store a number with only a very small range of values?