row count from dba_tables and count(*)
772780May 27 2010 — edited May 27 2010Can there be differenece in the row count of a table when chceked in the NUM_ROWS column from DBA_TABLES and by using count(*)?
Select NUM_ROWS from DBA_TABLES where TABLE_NAME = 'ABC';
Output: 765
Select count(*) from ABC;
Output: 34492
What would be the reason for the difference of the values? And what should be done to get these in sink?
I'm using Oracle version 10g
Regards,
SY