Skip to main content

Oracle analyzing index status

begin
  for i in (select index_name from user_indexes) loop
     execute immediate 'analyze index '||i.index_name||' validate structure';
     insert into indstat select * from index_stats;
  end loop;
  commit;
end;

Comments

Popular posts from this blog