What is R_PLANS?

Started by Roberto Moredaover 26 years ago2 messagesgeneral
Jump to latest
#1Roberto Moreda
moreda@sanluis.net

Please, can someone tell me what is the variable R_PLANS?

TIA

Roberto

--
Roberto Moreda
Resp. Dpto. Inform�tica Handem/San Luis
Tlf +34 981 779000
Fax +34 981 779022
Pol. Piadela Sur, Autov�a A6 Sal.567
15300 Betanzos (A Coru�a) - Espa�a

#2Bruce Momjian
bruce@momjian.us
In reply to: Roberto Moreda (#1)
Re: [GENERAL] What is R_PLANS?

[Charset iso-8859-1 unsupported, filtering to ASCII...]

Please, can someone tell me what is the variable R_PLANS?

In 6.5.*, rplans are on by default. They allow multi-table joins to be
on the inside of a join, rather than only outer, which is a left-handed
join. See src/backend/optimizer/README.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@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