A similarity query over 2 million rows runs as a sequential scan despite an HNSW index existing. What is the most likely cause?
- A The query uses a different distance operator than the index operator class (correct answer)
- B HNSW does not support large tables
- C The table needs VACUUM FULL
- D work_mem is too high
Shortcut: pgvector indexes are operator-class specific. Querying with <-> against an index built for cosine cannot use that index, so the planner falls back to a full scan.