|Subject||Re: [ib-support] Index problem|
|Author||Svein Erling Tysvær|
>I have seen, that before I deactivate and activate my indices thethem
>RDB$INDEX_INACTIVE-column is null for all my indices and after activating
>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> = ...