Indexes and OR clauses.

Поиск
Список
Период
Сортировка
От Keith Parks
Тема Indexes and OR clauses.
Дата
Msg-id 199802132345.XAA27580@mtcc.demon.co.uk
обсуждение исходный текст
Список 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.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: al dev
Дата:
Сообщение: performace speed up suggestions.
Следующее
От: Ryan Kirkpatrick
Дата:
Сообщение: Re: [HACKERS] PostGreSQL v6.2.1 for Linux Alpha