dakotali kasap wrote:

>  Therefore, I want to say the join-method that
> will be used or which relation will be outer which one will be inner.
> (I cannot do this just using SELECT * FROM a JOIN b).

You can't force the system to use a particular join method, but you can
select which one is inner and which one is outer -- you just need to set
join_collapse_limit to 1, and write the query in the specific order you
want.  See




(sorry, pointers to development-version docs).

Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to