Skip site navigation (1) Skip section navigation (2)

Re: Index not used in join.. (example included)

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Index not used in join.. (example included)
Date: 2009-09-18 12:41:09
Message-ID: 5a8aa6680909180541q3eb331ffse025782555c6e2ee@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
2009/9/18 Michael Wood <esiotrot(at)gmail(dot)com>:
> 2009/9/18 Ron Arts <ron(dot)arts(at)neonova(dot)nl>:
>> A. Kretschmer schreef:
> [...]
>>> You can try to force an index-scan by disabling the seq-scan (set
>>> enable_seqscan='no';) and re-run the query.
>>
>> That does force it to use the index, but doesn't speed up my query.
>
> Would it help to add an index on the name column of the detail table?
> And maybe to make it a foreign key referencing the first table?

Sorry, I just had another look and see you do have an index on the
name column in detail.

I wonder if it would make a difference if the index on the first table
was a unique index.

--
Michael Wood <esiotrot(at)gmail(dot)com>

In response to

Responses

pgsql-novice by date

Next:From: Ron ArtsDate: 2009-09-18 13:15:15
Subject: Re: Index not used in join.. (example included)
Previous:From: Michael WoodDate: 2009-09-18 12:38:27
Subject: Re: Index not used in join.. (example included)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group