Re: Which side of a Merge Join gets executed first? Do both sides always get executed?

Поиск
Список
Период
Сортировка
От Frédéric Yhuel
Тема Re: Which side of a Merge Join gets executed first? Do both sides always get executed?
Дата
Msg-id e7791357-4f29-4396-8419-daa14cbd52c6@dalibo.com
обсуждение исходный текст
Ответ на Which side of a Merge Join gets executed first? Do both sides always get executed?  (Jerry Brenner <jbrenner@guidewire.com>)
Ответы Re: Which side of a Merge Join gets executed first? Do both sides always get executed?  (Jerry Brenner <jbrenner@guidewire.com>)
Список pgsql-performance
Дерево обсуждения 

Le 20/12/2023 à 15:40, Jerry Brenner a écrit :
> Whichever side gets executed first, is the execution of the side that 
> would be second get short circuited if 0 rows are returned by the first 
> side?

Indeed, if 0 rows are returned from the outer relation, the scan of the 
inner relation is never executed.

Best regards,
Frédéric

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

Предыдущее
От: Frédéric Yhuel
Дата:
Сообщение: Re: Which side of a Merge Join gets executed first? Do both sides always get executed?
Следующее
От: Jerry Brenner
Дата:
Сообщение: Re: Which side of a Merge Join gets executed first? Do both sides always get executed?