RE: [HACKERS] Bug on complex subselect (was: Bug on complex join)

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 just GOSUB without RETURN.