On 10 Apr 2006 at 20:51, 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.

It may improve instant performance, but problem is being just
accumulated and will return in bigger size.

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

You can modify your queries in order not to use these indexes.

--
SY, Dimitry Sibiryakov.