Incorrect Record Count amount shown in the Query Builder (4243537)

Incorrect Record Count amount shown in the Query Builder

The record count in the Query Builder shows only the amount of rows that have been temporarily retrieved, as opposed to the full amount of rows in the table.

===========
Example 1:
counting the number of records of a table with e.g. 35000 records

select count(*) from table

results in 35000 records

 

Example 2:

Counting records in data grid of Query Builder with right mouse button and menu item "record count" only counts the records loaded temporarily

e.g.:
fetched 500 records -> Record Count shows 500 records
fetched 1000 records -> Record Count shows 1000 records

Although more rows exist in the table, e.g. 35000
===========​

This particular record count in the Query Builder is the default behavior for how data is queried in Toad and is done so by design for performance and optimization reasons.

It'll fetch data in groups of records. The option to determine the size of the group is in Toad's options on the Oracle -> General page: OCI Array Buffer Size. The default option is "Automatic" which will display 500 records at a time. You can change the setting, however, the maximum size available is 9999.

WORKAROUND:
Issue is fixed in the latest Toad Beta 13.1.0.24, available here

STATUS:
Waiting for fix in a future release of Toad for Oracle

TOR-2790

Record count in Query Builder now shows full amount of rows, regardless of how many rows are loaded via the OCI buffer