Optimizer question with equivalent joins

Поиск
Список
Период
Сортировка
От Dirk Lutzebaeck
Тема Optimizer question with equivalent joins
Дата
Msg-id 15635.14203.405079.671597@cayambe.core.aeccom.com
обсуждение исходный текст
Ответы Re: Optimizer question with equivalent joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hello,

say I have a join which says
   t.a = t.b and t.b = t.c

do I need to give the optimizer a hint by saying it more redundantly
   t.a = t.b and t.b = t.c and t.c = t.a

or is this just counter productive because there is one more join?

In the real world I have 10-20 equivalent joins which would really
blow up if I have to choose the second option.

Dirk




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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: how to sort a birthday list ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Optimizer question with equivalent joins