Oracle Rapid Statistics Large table total record number __oracle

You're still struggling to figure out how to quickly count the total number of records in a table with lots of data.

Are you still using SELECT COUNT (*) from table_name?

I can try my new discovery:

Direct COUNT (*) is time-consuming when you want to count tens of millions or billions of data, and tens of millions of of the data is expected to wait several minutes.

The total number of records in a quick query table:

Select table_name, T.num_rows, t.last_analyzed from tabs t;

Here you can find out the number of records in all the tables for this user in the database.

After the query data found that the data obtained from the tabs table is not very accurate, in the tabs table there is a field last_analyzed, there is a final analysis of the date,

seem to be not up to date, and may result in data not being very accurate.

You can do this by following the command

EXEC dbms_stats.gather_table_stats (' Space name ', ' tablename ', cascade=>true);

You can refresh the Num_rows column in the tabs table and the last update time