|Subject||Re: [firebird-support] Index Selectivity|
> > Index IDX_LOGSHIFTNUM (1)Interesting - I dropped this index, and the result was that it took a sp
> > 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.
from seconds to minutes ... I will have to investigate why ...
[Non-text portions of this message have been removed]