>> henrik.sorensen_at_balcab.ch wrote:
>>> use the found set of D.bids to join
>>> using matching indexes on C and B respectively, and finally join to the
>>> matching records in A, also using indexes.

>

>> what postgreSQL does is joining B with A then joins this result again
>> with C, but it doesn't use indices for this (see the output: Seq Scan
>> on c, Seq Scan on b, Seq Scan on a (this could be because of there are
>> no statistics and the query is still fast enough))