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_at_individual.net>
> I don't really believe this in this case.
> Because why would postgreSQL choose to use an index in the much smaller
> table E ?
> Henrik
>
>
Received on Tue Nov 08 2005 - 23:16:20 CET
Date: Tue, 08 Nov 2005 23:16:20 +0100
Message-ID: <3tcmdkFs1ohrU2_at_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 - 23:16:20 CET