Hello, Dmitri! >кода не больше 30-40 строк. 2 запроса.
Кто меньше?-) Для FB 1.5.x работает такое: 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 WBR,Dmitry Beloshistov AKA [-=BDS=-]