It may happen that we created an index and yet PostgreSQL doesn’t use it. What could be the reason and how to fix it? We identified 11 distinct scenarios. Read on to find out.
Important Things
Indexes may be tricky. We already covered how they work in another article. Let’s quickly recap important parts about how they work.