>I have seen, that before I deactivate and activate my indices the
>RDB$INDEX_INACTIVE-column is null for all my indices and after activating

them

>there is a 0. where is the difference between NULL and 0 in this case ?

Should not matter, the change is the same if you issue ALTER INDEX <name>
INACTIVE and then ACTIVE again. I guess it is just that the field isn't set
when creating the index.

I'm puzzled by your problem. I tried the same statement as you wrote (well,
using IB_SQL, not a SP), and didn't notice any degradation when trying a
SELECT COUNT ... WHERE <IndexField> = ...

Set