Re: union all vs. left outer join

From: Stefan Rybacki <stefan.rybacki_at_gmx.net>
Date: Tue, 08 Nov 2005 23:16:20 +0100
Message-ID: <3tcmdkFs1ohrU2@individual.net>

henrik.sorensen_at_balcab.ch wrote:
> Harald Fuchs wrote:

>...

> I don't really believe this in this case.
> Because why would postgreSQL choose to use an index in the much smaller
> table E ?

It's like I said, it's because of missing statistics. After I built the statistics for those tables, postgreSQL didn't use indices anymore.

Regards
Stefan

>...

> Henrik
>
>
Received on Tue Nov 08 2005 - 16:16:20 CST