摘要: Exec dbms_stats.gather_schema_stats( ownname => 'cbs', options => 'GATHER AUTO', estimate_percent => dbms_stats.auto_sample_size, method_opt => 'for all indexed columns ', degree => 6 ) ;创建统计信息历史保留表exec dbms_stats.create_stat_table(ownname => 'cbs',s 阅读全文
posted @ 2012-11-20 22:11 wuxi812 阅读(390) 评论(0) 推荐(0) 编辑