摘要:
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
阅读(417)
评论(0)
推荐(0)
浙公网安备 33010602011771号