I've been using "2. Get row count from all Tables" for some time now to monitor the size of tables and their changes over time. Today, I noticed that some of the numbers on our system do not match up.
Using the "2. Get row count from all Tables" script I receive:
table name - 510312 records
When I run: "select count(*) from tablename" I receive
510542 records
This has me puzzled. I thought the two outcomes should be the same. Would anyone have a solution about this? Has anyone experienced anything similar? Thanks.
Jan S.