• Often, small tables are used as foreign key lookups.

    In that case, I prefer an surrogate integer clustered primary key to minimize the amount of space required in the child tables.