RE: [HACKERS] Bug on complex subselect (was: Bug on complex join) - Mailing list pgsql-hackers

Hi!

On Thu, 11 Mar 1999, Jackson, DeJuan wrote:
> > > Make sure you have indexes on pos_id, shop_id, distr_id, 
> > and city_id.
> > 
> >    All these are primary keys in corresponding tables, and hence have
> > UNIQUE indicies. Is it enough?
> > 
> > Oleg.
> You should have indexes on both the primary and the referenced table.
> (i.e. positions.pos_id and central.pos_id)  It gives PostgreSQL more
> options on which join methods to use while still having an index to
> reference.
  Understand.  Thank you.

> 
>     -DEJ
> 

Oleg.
----    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net          Programmers don't die, they
justGOSUB without RETURN.