SQL LIKE Query Is Slow
A leading wildcard can prevent efficient index seeking.
LIKELY CAUSE
Why it happens
Use a prefix search where possible or consider full-text/search structures for contains queries.
SAFE FIX
What to do
Measure first; do not remove correctness just to chase speed.
Debug in this order
- Reproduce the problem on the smallest sample that still fails.
- Inspect the exact keys, types, ranges or markup involved instead of only the displayed value.
- Fix the root cause, then rerun the original case and one known-good case.
- Document the rule if the same problem can return in recurring work.
Do not hide an unexplained data error with a cosmetic workaround. Make the input and matching logic predictable first.