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

Yes.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com