>
>Ann W. Harrison wrote:
> > Do you have an index with lots of duplicates?

At 10:42 PM 11/22/2004, Alexander Marx wrote:

>aah .. i think we might have a winner here ...
>(and just for my defense, i didn't design that database :-)
>
>
>ACCOUNTRECORD (141)
>
> Index FK_ACCOUNTR_ACCR_ACCR_ACCOUNTR (4)
> Depth: 3, leaf buckets: 3430, nodes: 2308586
> Average data length: 0.00, total dup: 2308437, max dup: 1866983
>
>however, just dropping that constraint (and losing referential integrity)
>is probably not an option ... but i'll talk to our developers and see if
>they can redesign something in the db in question ...

They could replace that constraint with a trigger - slightly less
reliable, but probably good enough unless the parent is very volatile.

Regards,


Ann