Subject Re: [firebird-support] Odd optimizer behaviour
Author Alexandre Benson Smith
pi3k14 wrote:
> I have defined an UNIQUE field in one table, this field is used in
> joins to several other tables (used as foreign key).
>
> But I notice that the index created for this unique property is not
> used in the plans for my joins !?
>
> If I create a specific index for this field, that index is used.
>
>
> Anyone have any idea why this is happening?
>
>
> ---
> frode
>
outdated statistics ?

see you !

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