Multicolumn Index on OR conditions

From: Job <Job(at)colliniconsulting(dot)it>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Multicolumn Index on OR conditions
Date: 2017-09-19 08:08:30
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08180ABD2127@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

within a query with two or more conditions with "OR", example:

"where a = 2 or b < 3"

could be useful to speed up the query a multi-column index (a,b) even though the two conditions are in "OR" and not in "AND"?

Thank you!
F

Responses

Browse pgsql-general by date

  From Date Subject
Next Message vinny 2017-09-19 08:25:27 Re: Multicolumn Index on OR conditions
Previous Message Frank Millman 2017-09-19 05:06:42 Re: a JOIN to a VIEW seems slow