explicit JOIN faster than implicit?

Поиск
Список
Период
Сортировка
От Eric Schwarzenbach
Тема explicit JOIN faster than implicit?
Дата
Msg-id 4A79FCF8.5030606@blackbrook.org
обсуждение
Ответы Re: explicit JOIN faster than implicit?
Re: explicit JOIN faster than implicit?
Re: explicit JOIN faster than implicit?
Список pgsql-general
I'm in the process taking a large SELECT statement which had been
written using implicit join syntax (that is, just listing all the tables
in the FROM clause, and listing join conditions in the WHERE clause) and
rewriting it to use explicit JOIN syntax (they are all inner joins).
This has sped up the query by 50%.

This is using Postgres 8.3 on a database with GEQO turned off.

Is this what would be expected? Does the query planner / optimizer
generally do better with explicit JOIN syntax?

Cheers,

Eric

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