Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: union all vs. left outer join

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US