You should define tables such that they occupy minimum space on disk while accommodating all possible values.
If the size is smaller:
- Less data is written to or read from the disk, which makes queries faster.
- The contents on the disk are loaded to the main memory while processing queries. So, smaller tables occupy less space in the main memory.
- Less space is occupied by indexes.