表分析和索引分子
表分析查询语句
Select 'execute dbms_stats.gather_table_stats(''' || owner || ''',''' || table_name || ''');' from all_tables wHeRE OwNeR ='NETRESDB';
索引分析查询语句
Select 'execute dbms_stats.gather_index_stats(''' || owner || ''',''' || index_name || ''');' from all_indexes wHeRE OwNeR ='NETREPDB';