declare
ssql varchar2(100);
begin
for tabs in (select table_name from user_tables) loop
ssql := 'analyze table ' || tabs.table_name || ' estimate statistics';
execute immediate ssql;
end loop;
end;
/
declare
ssql varchar2(100);
begin
for inds in (select index_name from user_indexes) loop
ssql := 'analyze index ' || inds.index_name || ' compute statistics';
execute immediate ssql;
end loop;
end;
/