V
Или они NDA?
помогите новичку плзCREATE OR REPLACE procedure public.z_update_stat()
AS
$BODY$
DECLARE
aTableName text;
aSQL text;
TableCursor CURSOR for SELECT table_name FROM information_schema.tables WHERE table_type = 'base table';
begin
OPEN TableCursor;
LOOP
FETCH NEXT FROM TableCursor INTO aTableName;
aSQL = 'UPDATE STATISTICS [' + @TableName + '] WITH FULLSCAN, NORECOMPUTE;';
EXECUTE (aSQL);
end LOOP;
CLOSE TableCursor;
DEALLOCATE TableCursor;
end;
$BODY$
LANGUAGE 'plpgsql'
