Re: Lotsa joins

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Lotsa joins
Дата
Msg-id 200202061156.g16BuCT01913@candle.pha.pa.us
обсуждение исходный текст
Ответ на Lotsa joins  (Herb Blacker <herbblacker@isgenesis.com>)
Список pgsql-general
Herb Blacker wrote:
> Couldn't find it in the manuals...is there a limit to the number of
> tables that can be joined in a single query?
> Is there a better way of joining a central table through several bridge
> tables to their lookup tables?

No limit, in fact, we have GEQO which automatically reduces problems
with expoential growth of optimizer choices.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

Предыдущее
От: Justin Clift
Дата:
Сообщение: [Fwd: MS SQL compatible functions]
Следующее
От: "Yogesh Kansal"
Дата:
Сообщение: Re: Commit , Rollback