Indexes and OR clauses.
Keith Parks <emkxp01@mtcc.demon.co.uk>
From: Keith Parks <emkxp01@mtcc.demon.co.uk>
To: hackers@postgresql.org
Date: 1998-02-13T23:45:04Z
Lists: pgsql-hackers
Hi All, I know I'm not capable of locating or fixing the problem with this so it's a it of a cheek asking but... Is it time to increase the priority of the TODO item:- * Allow indexes to be used with OR clauses This would seem particularly important with the new subselect functionality. (Great work vadim) Many subselect-using queries use the "IN" keyword which we translate to a string of "OR"s so could potentially benefit from index useage. Keith.