Firebird Interview Question:

How to activate all indexes in Firebird?

Submitted by: Administrator

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 rdb$system_flag = 0
Submitted by: Administrator