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 http://momjian.us/main/writings/pgsql/sgml/runtime-config-query.html#RUNTIME-CONFIG-QUERY-OTHER and http://momjian.us/main/writings/pgsql/sgml/explicit-joins.html (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