Re: [SQL] Controlling join order with parenthesis

2010-09-09 Thread Tom Lane
"Marc Mamin" writes: > According to the documentation, I thought it was possible to force given > join orders with parenthesis. You can do that if you dial down join_collapse_limit. Bear in mind that leaves you *solely* responsible for picking an intelligent join order. I wouldn't recommend it a

[SQL] Controlling join order with parenthesis

2010-09-09 Thread Marc Mamin
Hello, According to the documentation, I thought it was possible to force given join orders with parenthesis. But in this small example, this seems to have no effect; With the first query, I'd expected to see t3 in the Merge Right Join but both queries return the same query plan . I'm missin