sql语句大小写迷糊

显示全部楼层 · 2014-11-11 06:00:14

SQL> select count(*) from testb;
COUNT(*)
----------
6
SQL> commit;
SQL> select tablespace_name,table_name,NUM_ROWS from dba_tables
2where owner='LIDONGJIE';
TABLESPACE_NAME
TABLE_NAME NUM_ROWS
------------------------------ ------------------------------ ----------
TEST
TESTA_RENAME
TEST
TESTB
TEST
TESTC
USERS
TABLED
SQL> SELECT tablespace_name,table_name,num_rows
2FROM dba_tables
3WHERE owner='LIDONGJIE';
TABLESPACE_NAME TABLE_NAMENUM_ROWS
------------------------------ ------------------------------ ----------
TEST
TESTA_RENAME
TEST
TESTB
TEST
TESTC
USERS
TABLED
怎么select语句中NUM_ROWS一列为空？求解释。

千问 · 2014-11-11 06:00:14

没收集统计信息

千问 · 2014-11-11 06:00:14

收集统计信息

千问 · 2014-11-11 06:00:14

SQL> BEGIN
2 DBMS_STATS.GATHER_TABLE_STATS(ownname => 'LIDONGJIE',
3
taBNAME =>'TABLED',
4estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
5 method_opt => 'for all columns size repeat',
6
degree => DBMS_STATS.AUTO_DEGREE,
7
cascade=>TRUE
8
);
9END;
10/
已经解决，谢谢两位。