performance - self-joins vs. subqueries

Поиск
Список
Период
Сортировка
Искать
От
K. Ari Krupnikov
Тема
performance - self-joins vs. subqueries
Дата
Msg-id
3A880244.4F0C5F5F@iln.net
Список
Дерево обсуждения
Re: performance - self-joins vs. subqueries "K. Ari Krupnikov" <ari@iln.net>
Re: performance - self-joins vs. subqueries Tom Lane <tgl@sss.pgh.pa.us>
Many queries can be formulated as either a self-join or a subquery on
the same table.

Is there any difference in performance, or does the analyzer treat them
the same?


-- 
K. Ari Krupnikov

DBDOM - bridging XML and relational databases
http://www.iter.co.il
В списке pgsql-general по дате отправления
От: Bruce Momjian
Дата:
От: adb
Дата:
FAQ