Re: Throwing unnecessary joins away

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Throwing unnecessary joins away
Дата
Msg-id 5269.1137081233@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Throwing unnecessary joins away  (Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>)
Ответы Re: Throwing unnecessary joins away  (Szűcs Gábor <surrano@gmail.com>)
Re: Throwing unnecessary joins away  (Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>)
Список pgsql-performance
=?ISO-8859-1?Q?Ott=F3_Havasv=F6lgyi?= <havasvolgyi.otto@gmail.com> writes:
> As far as I know SQL Server has some similar feature. It does not join
> if not necessary, more exactly: if the result would be the same if it
> joined the table.

I find it really really hard to believe that such cases arise often
enough to justify having the planner spend cycles checking for them.

            regards, tom lane

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

Предыдущее
От: Jamal Ghaffour
Дата:
Сообщение: Re: Please Help: PostgreSQL performance Optimization
Следующее
От: Szűcs Gábor
Дата:
Сообщение: Re: Throwing unnecessary joins away