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 noteEverything 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(at)Sheeky(dot)Biz> To: regmeplease(at)gmail(dot)com> CC: pgsql-general(at)postgresql(dot)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.
http://im.live.com/Messenger/IM/MTV/?source=text_Cause_Effect