Removing Inner Joins

Поиск
Список
Период
Сортировка
От Atri Sharma
Тема Removing Inner Joins
Дата
Msg-id CAOeZVif9+2DwemkkAdcua1mftxSoeEtDBbUJE_DXjVJoqy=T_g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Removing Inner Joins  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-hackers
Hi all,

I was reading about the plans to add functionality to the planner to
remove redundant inner joins where there is no member of the inner
relation present in the target list and the inner relation is only
used for the join clause. Also, we have a foreign key in the outer
relation to the inner relation.

Where are we with that functionality atm? Do we have plans to move forward?

Also, how difficult is it to go ahead with it?

Regards,

Atri


--
Regards,

Atri
l'apprenant



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

Предыдущее
От: Hitoshi Harada
Дата:
Сообщение: Re: [PATCH] Add transforms feature
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Removing Inner Joins