Svein Erling Tysvær wrote:

>Why would Firebird even seriously consider the plan it chose and
>prefer using NATURAL over the PK when the query involves two
>similarly-sized tables? I might have followed its logic (though I
>would have disagreed) if it was the IDX_DIAGNOSIS it chose to ignore,
>but I consider our PKs to be extremely selective ;o)
>
>Confused,
>Set
>
>

Set,

If you are puzzled about query plans what do you expect from others ? :-)))

I think that just Ann and Arno could help here.

I am interested on it too, did you checked the same on FB 2.0 ? I did
some tests and get far better plans with it.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.6/33 - Release Date: 28/06/2005