Agreed. Basically a GUI widget/button/whatever that calls
set term !! ;
EXECUTE BLOCK AS
declare variable index_name VARCHAR(31);
BEGIN
for select RDB$INDEX_NAME from RDB$INDICES into :index_name do
execute statement 'SET statistics INDEX ' || :index_name || ';';
END!!
set term ; !!
would do the trick
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Agreed. Basically a GUI widget/button/whatever that calls
set term !! ;
EXECUTE BLOCK AS
declare variable index_name VARCHAR(31);
BEGIN
for select RDB$INDEX_NAME from RDB$INDICES into :index_name do
execute statement 'SET statistics INDEX ' || :index_name || ';';
END!!
set term ; !!
would do the trick