Oracle Analyze Command 를 통해 전체 통계치 재 생성하기

select table_name, num_rows, to_char(last_analyzed, 'yyyymmdd') from user_tables;

select index_name, num_rows, to_char(last_analyzed, 'yyyymmdd') from user_indexes;
 
select 'analyze table ' || table_name || ' estimate statistics;' from user_tables;

select 'analyze index ' || index_name || ' estimate statistics;' from user_indexes;