I'm using the embedded version of Firebird 2.5 for Windows. I'm looking
to improve some query performance by adding indices to my tables. From
what I read I should recalculate the index statistics after I alter the
contents of a table by running:

SET STATISTICS INDEX index_name

I also read that I can check the statistics value by looking at the
RDB$INDICES.RDB$STATISTICS column for the given index. For some reason
all my statistics values are all -1.0000. Is that normal? I was under
the impression that statistics values ranged from 0 to 1. Is there some
else I need to do to recalculate the values?

Thanks,

Dave



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