Proactive Maintenance
摘要:
1.执行统计分析 SQL> create table hr.a tablespace data01 as select * from hr.employees; SQL> select num_rows from dba_tables where owner='HR' and table_name='A'; --执行结果为空 SQL> exec dbms_stats.gather_table_stats('HR','A'); 再次查询: SQL> select num_rows from dba_table 阅读全文
posted @ 2013-06-07 21:30 newmanzhang 阅读(182) 评论(0) 推荐(0) 编辑