Hello,

> instead of daily backup/restore I'd like to recompute automatically all
> indexes, something that will generate following script for isql:
>
> alter index A inactive;
> alter index A active;
> ...
> alter index Z inactive;
> alter index Z active;
>
> Is there any solution with standard command line programs - isql, gpre ?

What do you mean by "solution"? Something to create the script
for you?

You should be able to do that with some fancy SQL:

select 'alter index ' || rdb$index_name || ' inactive;'
from rdb$indices

etc...

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com