Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Multicolumn Index on OR conditions - Mailing list pgsql-general

From Job
Subject [GENERAL] Multicolumn Index on OR conditions
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08180ABD2127@W2008DC01.ColliniConsulting.lan
Whole thread Raw
Responses Re: [GENERAL] Multicolumn Index on OR conditions  (vinny <vinny@xs4all.nl>)
Re: [GENERAL] Multicolumn Index on OR conditions  (legrand legrand <legrand_legrand@hotmail.com>)
List pgsql-general
Tree view 
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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: "Frank Millman"
Date:
Subject: Re: [GENERAL] a JOIN to a VIEW seems slow
Next
From: vinny
Date:
Subject: Re: [GENERAL] Multicolumn Index on OR conditions