query plan and parenthesis

Поиск
Список
Период
Сортировка
От Jan Poslusny
Тема query plan and parenthesis
Дата
Msg-id 3EE99C49.8030001@gingerall.cz
обсуждение исходный текст
Ответы Re: query plan and parenthesis
Список pgsql-general
Hi,
I have following view definition given by '\d' command: SELECT t1.col1
FROM ((table1 t1 JOIN table2 t2 ON ((t1.id = t2.id))) JOIN table3 t3 ON
((t2.some = t3.some)));
Is query planner able to optimize order of joining (t1, t2), t3 or must
join with order described by parenthesis ? This is very important for
joining small (50 rows) and huge (5M rows) tables.


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