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

2009/9/18 Michael Wood <esiotrot@gmail.com>:
> 2009/9/18 Ron Arts <ron.arts@neonova.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@gmail.com>