表和索引的分析脚本

exec dbms_stats.delete_index_stats(ownname => 'NTCOMM',indname => 'I_FKK_PRODUCT_203') ; 
exec dbms_stats.gather_index_stats(ownname => 'NTCOMM',indname => 'I_FKK_PRODUCT_203',estimate_percent => '10',degree => '4') ;


exec  dbms_stats.delete_table_stats(ownname => 'NTCOMM',tabname => 'SERV_PRODUCT') ; 
exec dbms_stats.gather_table_stats(ownname => 'NTCOMM',tabname => 'SERV_PRODUCT',estimate_percent => 10,method_opt=> 'for all indexed columns') ;


exec  dbms_stats.delete_table_stats(ownname => 'NTCOMM',tabname => 'SERV_STATE_ATTR') ; 
exec dbms_stats.gather_table_stats(ownname => 'NTCOMM',tabname => 'SERV_STATE_ATTR',estimate_percent => 10,method_opt=> 'for all indexed columns') ;


exec dbms_stats.delete_table_stats(ownname => 'NTCOMM',tabname => 'PRODUCT_OFFER_INSTANCE') ; 
exec dbms_stats.gather_table_stats(ownname => 'NTCOMM',tabname => 'PRODUCT_OFFER_INSTANCE',estimate_percent => 10,method_opt=> 'for all indexed columns') ;


exec dbms_stats(ownname => 'NTCOMM',tabname => 'PRODUCT_OFFER_INSTANCE_DETAIL') ; 
exec dbms_stats.gather_table_stats(ownname => 'NTCOMM',tabname => 'PRODUCT_OFFER_INSTANCE_DETAIL',estimate_percent => 10,method_opt=> 'for all indexed columns') ;