Firebird Question:
How to activate all indexes in Firebird?
Answer:
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
select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;'
from rdb$indices
where rdb$system_flag is not null and rdb$system_flag = 0
| Previous Question | Next Question |
| Can I concurrently access a Firebird database with embedded and with regular server? | How to add, remove, modify users using SQL? |