Sqlt9i is reporting NumRows=0 - when table has statistics
Sqlt9i is reporting NumRows=0 - when table has statistics run by
spool /export/home/oracle/dba/logs/analyze_schemas.log
execute dbms_stats.gather_schema_stats(ownname=>'VA',cascade=>true);
execute dbms_stats.gather_schema_stats(ownname=>'ODS',cascade=>true);
execute dbms_stats.gather_schema_stats(ownname=>'DM',cascade=>true);
SQL> select last_analyzed from dba_tables where table_name='STG_MOVE_PHYSICAL_DEVICE';
LAST_ANAL
---------
09-APR-11
SQL>
spool /export/home/oracle/dba/logs/analyze_schemas.log
execute dbms_stats.gather_schema_stats(ownname=>'VA',cascade=>true);
execute dbms_stats.gather_schema_stats(ownname=>'ODS',cascade=>true);
execute dbms_stats.gather_schema_stats(ownname=>'DM',cascade=>true);
SQL> select last_analyzed from dba_tables where table_name='STG_MOVE_PHYSICAL_DEVICE';
LAST_ANAL
---------
09-APR-11
SQL>
0