Not all index scans are equal: How we cut query latency by over 99%

Just because your query uses an index scan doesn't mean it's fast or performant. Learn how misaligned predicates and column order hurt index scan performance and how to detect this pattern using DBM.