Answers

Question and Answer:

  Home  Firebird

⟩ 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 rdb$system_flag = 0

 150 views

More Questions for you: