Hello, I do have a quite suspicious behavior of the Qery-Optimizer (I
think):
If I execute the following statement:
query: explain select k.name, t.lang from kneipe k, typ t where
k.typ=t.typ;
ProcessUtility: explain select k.name, t.lang from kneipe k, typ t where
k.typ=t.typ;
NOTICE: QUERY PLA
Peter Eisentraut wrote:
[..]
>
> Sure it's used. Just because it's not mentioned in the select list doesn't
> mean it will be ignored completely. What you get here is a three-way join,
> which is of course slower than a two way join.
What I do not understand at all: The table "preis" is neither
"Mitterwald, Holger" <[EMAIL PROTECTED]> writes:
> Seems ok to me, but if I insert a (huge) table which is nowhere
> referenced (here:"preis"), the
> following happens:
> query: explain select k.name, t.lang from kneipe k, typ t, preis p where
> k.typ=t.typ;
> NOTICE: QUERY PLAN:
> Merge Join
On Tue, 30 May 2000, Mitterwald, Holger wrote:
> If I execute the following statement:
> query: explain select k.name, t.lang from kneipe k, typ t where
> k.typ=t.typ;
> ProcessUtility: explain select k.name, t.lang from kneipe k, typ t where
> k.typ=t.typ;
> Seems ok to me, but if I insert a (h
