Jerome Bouvattier wrote:

>
> >
> > when we create foreign key an index is created, but this index can
> have a
> > very
> > weak selectivity and then the plan is not very good
>
>
> I believe the only way so far, is to drop the FK (along with the
> index) and
> do referential integrity related stuff ourselves in triggers.
>
> Can anyone confirm ?

I seem to remember a few threads in the past that have alluded to this
being the case. It's the way I have solved the problem in the past.