Often I'm confronted with a choice as to the size of the datatype of a given column
when designing a database. For the sake of discussion let's say I have a status code
which may take on any number of distinct numeric values. Perhaps there's a
relatively small number of distinct values, so I could choose a tinyint, smallint, or
Which choice is the "best"?
On the one hand, assuming I'll never get near a couple hundred values, then tinyint
would seem to make the most sense - it uses less space. But space is cheap these
days, and ...