Hello,

I thing it is ok, but the select should be

SELECT DISTINCT RDB$INDEX_NAME
FROM RDB$INDICES
WHERE RDB$SYSTEM_FLAG IS NULL

if you want to touch every non system index.

Jorge Cué


En un mensaje con fecha 20/03/2004 11:04:43 a.m. Hora estándar romance,
jsparrow@... escribe:

> 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

[Non-text portions of this message have been removed]