Subject | Re: [firebird-support] Odd optimizer behaviour |
---|---|
Author | Alexandre Benson Smith |
Post date | 2006-03-28T15:51:10Z |
pi3k14 wrote:
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> I have defined an UNIQUE field in one table, this field is used inoutdated statistics ?
> 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
>
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br