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

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

Is the 2.0 version a stable one to use in a production eviroment ?