1.

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 rdbSsystem_flag 0

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


Discussion

No Comment Found

Related InterviewSolutions