Type to use for “Status” columns in a sql table
I would go with number 4, but I’d use a char(x) column. If you’re worried about performance, a char(4) takes up as much space (and, or so one would think, disk i/o, bandwidth, and processing time) as an int, which also takes 4 bytes to store. If you’re really worried about performance, make it a … Read more