Where to read how 'or' in a query affects query performance in postgres?

I

impressive172021-08-31 21:46:58

PostgreSQL

impressive17, 2021-08-31 21:46:58

Where can one read how 'OR' in a query affects the performance of that query? And which indexes are better to use in this case?

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

D

Developer, 2021-08-31
@samodum

Documentation

V

Vladimir Korotenko, 2021-09-01
@firedragon

https://www.cybertec-postgresql.com/en/avoid-or-fo...
https://wiki.postgresql.org/wiki/Performance_Optim...
https://www.postgresql.org/docs/ 9.3/performance-ti...

S

Stanislav Shendakov, 2021-09-01
@shindax

EXPLAIN
https://postgrespro.ru/docs/postgrespro/9.5/using-...