Have several very large fact tables (100+ million rows).
In doing some maintainence on one of these fact tables, I can
squish the size of several of my dimension keys from int to smallint.
Don’t want to touch the other fact tables at this point in time.
Is there a performance penalty to having a dimension key in the fact table be
of size smallint but still be of size int in the dimension table when a join