Hi all,

Is it ok / sensible to do something like this periodically:

for select distinct rdb$index_name from rdb$indices where
rdb$index_type is not null into :indexname do
begin
execute statement 'set statistics index ' || indexname;
end


Thanks,

John