Firebird Question:
Download Questions PDF

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

Download Firebird Interview Questions And Answers PDF

Previous QuestionNext Question
Can I concurrently access a Firebird database with embedded and with regular server?How to add, remove, modify users using SQL?