FIREBIRD Questions and Answers

How to activate all indexes in Firebird?

If you run Firebird 1.x which doesn’t have EXECUTE BLOCK, you can run the following query:
select ALTER INDEX ‘||rdb$index_name|| ‘ ACTIVE:’
from rdb$indices
where rdb$system_flag is not null and rdbSsystem_flag 0