| Subject | Re: GBAK and the -i flag |
|---|---|
| Author | David Richmond |
| Post date | 2007-08-21T11:45:07Z |
--- Tom Miller wrote:
Run the following query:
SET TERM !! ;
EXECUTE BLOCK AS
DECLARE VARIABLE stmt VARCHAR(1000);
BEGIN
for select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;'
from rdb$indices
where rdb$system_flag is not null and rdb$system_flag = 0
into :stmt
do EXECUTE STATEMENT :stmt;
END!!
SET TERM ; !!
Regards,
Dave
> Turning off the indexes during restore makes a big difference duringhttp://www.firebirdfaq.org/faq274
> restore, but I noticed that the indexes do not get activated after
> restore is complete. Is their a simple way to do this (after the
> restore is complete) from the command line.
Run the following query:
SET TERM !! ;
EXECUTE BLOCK AS
DECLARE VARIABLE stmt VARCHAR(1000);
BEGIN
for select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;'
from rdb$indices
where rdb$system_flag is not null and rdb$system_flag = 0
into :stmt
do EXECUTE STATEMENT :stmt;
END!!
SET TERM ; !!
Regards,
Dave