When should you use the IN instead of the OR operator in Postgres?

Comments

• Arigion@feddit.de ⁨2⁩ ⁨years⁩ ago

  TLDR

  Based on our results, we find that PostgreSQL consistently exhibits equivalent or better performance for queries with an IN clause than OR clauses when filtering on a single attribute.

  source