Why is USER_TABLES.NUM_ROWS not getting updated
SQL> CREATE TABLE MYTEST
2 (ENAME VARCHAR2(15));
Table created.
SQL> INSERT INTO MYTEST VALUES('JOHN');
1 row created.
SQL> INSERT INTO MYTEST VALUES('LORRAINE');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> SELECT NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='MYTEST';
NUM_ROWS
----------
SQL> SELECT COUNT(NUM_ROWS) FROM USER_TABLES WHERE TABLE_NAME='MYTEST';
COUNT(NUM_ROWS)
---------------
0
It should be 2 since i've INSERTed two rows