The record counts on the same table displayed in Num Rows column and Record Count option of Schem (4219774)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

The record counts on the same table displayed in Num Rows column and Record Count option of Schem
Description

When a table name is selected in Schema Browser, the 'Num Rows' column on RHS of Schema Browser shows a different number than the number shown when right-clicking on the table name and selecting 'Record count' option. Why is there a discrepancy between these two numbers.
Resolution

To obtain the record number for NUM ROWS column of table, Toad runs a similar query from SYS.USER_ALL_TABLES data dictionary view:
Select t.table_name, round(t.num_rows) num_rows
from sys.user_all_tables t
where t.table_name = <table name>
To obtain the record count of table using “Record Count” option from the table right-click menu, Toad runs the following query in the background:
Select count(*) from <table name>
Note: Record count stored in sys.user_all_tables table view is stored the last time table was analyzed. Consult with Oracle to reanalyze the table.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title