Subject Re: [IB-Architect] Rebuilding foreign keys system indexes
Author Dmitry Kuzmenko
Hello, Marcelo!

Marcelo Lopez Ruiz wrote:

> > Also this will fix another problem when FK points to PK and thus there are
> > 2 or more indices (if there are 1 or more FK) on the same field.
> >
> There is a tool in the IB_Designer egroup that can check indexes and reports
> this situation.

And what it can do? Delete FKs? You can't delete FK index. If there are 2 FKs on the
same field, there will be 2 indices on the same field.

Dmitry Kuzmenko, Epsylon Technologies.