> > Index IDX_LOGSHIFTNUM (1)
> > Depth: 3, leaf buckets: 1149, nodes: 179393
> > Average data length: 0.00, total dup: 179090, max dup: 1400
>
>179090 duplicates out of 179393 nodes is a lot i would drop this index
>unless there a very specic reason for.

Interesting - I dropped this index, and the result was that it took a sp
from seconds to minutes ... I will have to investigate why ...

Regards

Tim


[Non-text portions of this message have been removed]