--- In firebird-support@yahoogroups.com, "diegodelafuente"
<diegodelafuente@...> wrote:

>
> I used the IBAnalyst trial version. I bought the full version, but i
> still waiting for it.
> I change the sweep interval to 0. That improve the performance a
> little.
> In the reports of the DB apears a lot bad indexes, because they have a
> lot of equals Data on it. But These indexes were created for F.Keys
> and they cannot be deleted until I delete the F.Key.
> I don´t won´t to do that, because i use them for Data Integrity.
> How can I solve this problem ?
>
> Again sorry for my english
> Diego

Firebird 2 will solve this problem for you. It does not have the same
issues with garbage collection with index with a lot of duplicates.

There is not much that can be done in Firebird 1.5. If the master
record is reasonably fixed, then you may be able to use triggers to
enfore the foreign key relationship to the detail table. If the master
record is changing, then isolation levels may allow inconsistent data
to be stored.

Adam