Re: Controlling join order with parenthesis

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Controlling join order with parenthesis
Дата
Msg-id 27781.1284040185@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Controlling join order with parenthesis  ("Marc Mamin" <M.Mamin@intershop.de>)
Список pgsql-sql
"Marc Mamin" <M.Mamin@intershop.de> writes:
> According to the documentation, I thought it was possible to force given
> join orders with parenthesis.

You can do that if you dial down join_collapse_limit.  Bear in mind that
leaves you *solely* responsible for picking an intelligent join order.
I wouldn't recommend it as a production setting.
        regards, tom lane


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

Предыдущее
От: "Marc Mamin"
Дата:
Сообщение: Controlling join order with parenthesis
Следующее
От: Greg Caulton
Дата:
Сообщение: sql disaster - subquery error but delete continues