Re: Mistake in my query or Index Scan on subquery failure? (7.4)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Mistake in my query or Index Scan on subquery failure? (7.4)
Дата
Msg-id 19055.1078356086@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Mistake in my query or Index Scan on subquery failure? (7.4)  ("Gellert, Andre" <AGellert@ElectronicPartner.de>)
Список pgsql-general
Дерево обсуждения 
"Gellert, Andre" <AGellert@ElectronicPartner.de> writes:
> Is it okay , that the word ref_artikel_pkey will be repeated for each
> condition ?

That's what it's supposed to do.  EXPLAIN is trying to tell you that
this query involves three independent index probes, which should not be
very surprising.

            regards, tom lane

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

Предыдущее
От: "Karl O. Pinc"
Дата:
Сообщение: Re: Moving from MySQL to PGSQL....some questions (multilevel
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Moving from MySQL to PGSQL....some questions (multilevel