>you'll probably have a pretty good idea which table you'll want to filter first, and what to join

Until the day you load a bunch of new data and it gets skewed, or you delete a bunch of data without shrinking and oops, your join order and method is not efficient anymore.