Performance Bottleneck Triage

When something is slow and you want one hypothesis to test rather than five guesses.

Here's a profiler output / slow query plan: [paste]. Identify the single largest contributor to latency and explain the mechanism (not just 'it's the loop'), then propose one targeted fix.

Anything in square brackets is meant to be replaced. The builder turns those into fields you can type into.