Обсуждение: Indexes and OR clauses.

Поиск
Список
Период
Сортировка

Indexes and OR clauses.

От
Keith Parks
Дата:
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.