lsbtreis wrote:

> ...
> Index FK_SIGV_5_VIDEOCAM2 (3)
> Depth: 2, leaf buckets: 289, nodes: 112341
> Average data length: 0.00, total dup: 112338, max dup: 62485
> Fill distribution:
> 0 - 19% = 1
> 20 - 39% = 1
> 40 - 59% = 246
> 60 - 79% = 1
> 80 - 99% = 40
> ...

This is not related to the subject (Database file grows), but anywhow:
"Max dup" of more than a few thousands is usually not a good thing, but
cannot always be avoided. If you can remove indexes with a high number of
duplicates you will have removed a possible speed problem.
This was also mentioned in the thread "random slowdowns".


--
Aage J.