Max Dup: 80 sounds OK to me, but it all depends on how you use your
database. It is lousy if it contains historical data and you
frequently do WHERE MyField < 'Yesterday'.

Set

--- In firebird-support@yahoogroups.com, "jameschua1021" wrote:
> This is the stats of my index, it's a date field.
>
> Leaf Bucket: 44
> Nodes: 29376
> Total Dup: 28622
> Max Dup: 80
> fill distribution: 60-79%: 1; 80-90%: 44
>
> Is it very good? good? fair? or Bad and have to remove it.
>
> Apinot