I was told today that having a table structure similar to this is bad for performance of indexes because of the mismatch of column types.
Table 1 id - int (7) PK Others ....
Table 2 id int (11) Index (has to exist in table 1 logically - though not enforced through FK) Others ....
I'm using MySQL with InnoDB.
The question I suppose could also be related to Varchar 200 vs 220 for example.
I know that the index size will be affected by the extra space per item needed (and storage space in general), probably in the 5-10% area, but will the time taken for joins to happen increase?