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?
--
Michael Wood <esiotrot(at)gmail(dot)com>