Explain how you would optimize a slow-running query that joins a massive user activity table with a smaller dimensions table for Reddit.
