Alright, so the remaining questions to someone with that knowledge are: - Does the problem going from 2.5.1 to 2.5.4 still only concern compound indices containing at least one NULLable (VAR)CHAR and no other indices than that? If not, what else?
- Is the following code enough to rebuild a superset of those, i.e. at least all indices that would give trouble? SET TERM !! ; EXECUTE BLOCK AS DECLARE VARIABLE stmt VARCHAR(1000); BEGIN for select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;' from rdb$indices where (rdb$system_flag is null or rdb$system_flag = 0) order by rdb$foreign_key nulls first into :stmt do EXECUTE STATEMENT :stmt; END!! SET TERM ; !! If not, then what should it be? Thanks a lot.
