[EMAIL PROTECTED] (Martin Gainty) writes:
> Not the planner but you can hint the query as in this example
> select /*+ ordered use_hash(code1)*/ * from table_1;
That might have some effect with Oracle; is there some reason why you
think this would be expected to have any effect on a PostgreSQL que
On Jan 1, 2008 10:27 AM, Martin Gainty <[EMAIL PROTECTED]> wrote:
>
> Not the planner but you can hint the query as in this example
> select /*+ ordered use_hash(code1)*/ * from table_1;
no, that's an oraclism.
---(end of broadcast)---
TIP 6: expl
PROTECTED]> 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
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
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?
--
Reg me, please!
---(end of broadcast)---
TIP 9: In
