Helen,

From: "Helen Borrie" <helebor@...>

> >Well, i use lookups inside the application (Delphi) so can put the
> >checks inside the middle tier in ASTA, and remove that foreign keys.
> >Can you tell me if the next version of firebird will change that or will
> >remain in the same way?
>
> No, I can't tell you that. I only know that Arno is working on a solution
> to the problem of long duplicate chains in those low-selectivity indexes.

What about telling an FK to use an user-defined index (more selective than
the default one) ?
Is this something planed for the future ?

Or is this more complicated to implement than it looks ?

--
Jerome