I have a users table that's getting pretty large (~ 2M rows) and that's very sparse, because most users register but don't do much, so a lot of the columns are NULL.
I'm thinking of adding a user_details table with a unique foreign key constraint to the users table, and moving all those rarely populated columns into it. A row in user_details would only be created it we need to populate one or more of the columns in there.
Is that an okay idea?
It doesn't violate any normalization rules, does it? And in practice, does it cause any problems?
