Not the planner but you can hint the query as in this example
select /*+ ordered use_hash(code1)*/ * from table_1;
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.
> Date: Wed, 2 Jan 2008 00:15:14 +1030
> From: pgsql@Sheeky.Biz
> To: regmeplease@gmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Hinting the planner
>
> Reg Me Please wrote:
> > Hello all.
> >
> > I have some tables that contain exactly 1 row and that I use for searches with
> > JOIN.
> >
> > Does it make any sense to hint the planner about this?
> > If so, how can I send such hints to it?
> >
>
> You don't give hints to the planner.
>
> The planner does use statistics gathered from an ANALYZE to generate the
> best plan, so if you haven't analyzed your db you will not likely get
> the best plans.
>
> see
> http://www.postgresql.org/docs/8.2/interactive/sql-analyze.html
>
> and
> http://www.postgresql.org/docs/8.2/interactive/sql-vacuum.html
>
> also
> http://www.postgresql.org/docs/8.2/interactive/maintenance.html
>
> can explain these tasks in more detail.
>
> If this is insufficient then you can also look at your config file.
>
>
>
> --
>
> Shane Ambler
> pgSQL (at) Sheeky (dot) Biz
>
> Get Sheeky @ http://Sheeky.Biz
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
i’m is proud to present Cause Effect, a series about real people making a difference.
Learn more