Thread

Indexes and OR clauses.

Keith Parks <emkxp01@mtcc.demon.co.uk> — 1998-02-13T23:45:04Z

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.