Re: [PERFORM] Optimization inner join

Поиск
Список
Период
Сортировка
От Phillip Couto
Тема Re: [PERFORM] Optimization inner join
Дата
Msg-id 07fa17ae-ed3c-42bb-8a63-e24093cbac3d@mtasv.net
обсуждение исходный текст
Ответ на Re: [PERFORM] Optimization inner join  (Vitalii Tymchyshyn <vit@tym.im>)
Список pgsql-performance
I apologize my statement about NULL being used to join is incorrect as both Vitalii and Gustavo have both pointed out in their respective replies.

-----------------
Phillip Couto



On Jan 19, 2017, at 08:30, Vitalii Tymchyshyn <vit@tym.im> wrote:


Hi.

In SQL "null == any value" resolves to false, so optimizer can safely skip nulls from either side if any for the inner join.

Best regards, Vitalii Tymchyshyn

NULL is still a value that may be paired with a NULL in a.a

The only optimization I could see is if the a.a column has NOT NULL defined while b.b does not have NOT NULL defined.

Not sure if it is all that common. Curious what if you put b.b IS NOT NULL in the WHERE statement?

-----------------
Phillip Couto





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

Предыдущее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: [PERFORM] Optimization inner join
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] Optimization inner join