Re: Want to use my own query-plan

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.