Dmitriy A. Beloshistov пишет:
create procedure SYS$SET_INDEXSTAT
returns (ACOUNT INTEGER)
as
declare variable AINDEXNAME varchar(100);
begin
ACOUNT=0;
FOR SELECT RDB$INDEX_NAME FROM RDB$INDICES
WHERE (RDB$SYSTEM_FLAG IS NULL) or (RDB$SYSTEM_FLAG<>1)
INTO :AINDEXNAME
DO BEGIN
EXECUTE STATEMENT 'SET STATISTICS INDEX '||:AINDEXNAME;
ACOUNT=ACOUNT+1;
END
suspend;
end
мы тоже так делаем :-) -- Regards, Ovchinnikov Vasily ova at tkvc ru
