Nope, it's only meant as a checking tool. To drop a system index, you need
to drop the constraint which it is meant to support, and enforce the
constraint 'by hand' (triggers, etc.).

At least, in the current version ;-)

The tool will report identical indexes and indexes which are prefixes of
others; eg:

index 1: last name
index 2: last name, first name

This may or may not be something you want in your database; all the tool
does is report the situation.

Marcelo

----- Original Message -----
From: Dmitry Kuzmenko <dima@...>
To: <IB-Architect@egroups.com>
Sent: Friday, November 03, 2000 6:39 AM
Subject: Re: [IB-Architect] Rebuilding foreign keys system indexes


> 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.
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>
>