Subject Re: Index Selectivity maintenance
Author Ian A. Newby
Hi Martijn,
Only so I could see the list of indexes rebuilt.

Its really going to be

CREATE PROCEDURE SYS_RECALC_SELECTIVITY
AS
declare variable indexname char(31);
begin
for select rdb$index_name from rdb$indices into :indexname do
begin
execute statement 'set statistics index ' || :indexname;
end
end

regards
Ian