Re: Use of Indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Use of Indexes
Дата
Msg-id 26637.1118602021@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Use of Indexes  ("Darrell A. Sullivan, II" <darrell@flores-associates.com>)
Список pgsql-general
"Darrell A. Sullivan, II" <darrell@flores-associates.com> writes:
> I was wondering if someone could answer a question about how PostgreSQL uses
> indexes when performing queries. Particularly, I need to know if the query
> optimizer will use more than index for a query or if it only uses one.

Versions through 8.0 can only use one index per query (per table).  8.1
will be smarter though.

            regards, tom lane

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