--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

>
> 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
>

Lost statistics in fact (sorry for the late reply, but something more
important ??! came up).

The statistics for all the indicies where 0.

How can that happen?

When I created a new index that got correct statistics.

This was a nasty fault :(

---
frode