SELECT DISTINCT game_id FROM vw_joints
Seeing distinct makes me cringe; most uses of it foreshadow either a poor design or a bad query; not always but more often than not.
If you’re really trying to do a distinct you can select from the game table and do an exists against plays and joints tables thus removing the distinct clause; but I digress as the given query is most likely an over simplified query just as example.
Partitioning does nothing here as the query doesn’t filter on the partitioned field thus no partition elimination.