摘要: create table t1(id int,name varchar(20));insert into t1 values(1,'tom');SQL> select num_rows,table_name from user_tables; NUM_ROWS TABLE_NAME---------- ------------------------------ T1//收集一下统计信息,就可以看到了SQL> CALL DBMS_STATS.GATHER_TABLE_STATS ('AAA','T1');SQL> select 阅读全文
posted @ 2014-03-25 20:11 kaka100 阅读(400) 评论(0) 推荐(0) 编辑