I am using a dynamic sql to get the counts of all the tables by passing the table name as follows:
v_str := 'SELECT COUNT(*) FROM ' || p_table;
Since some of the tables are huge, and contains millions of rows, getting the counts of some of the tables is taking longer and hence the over process is taking a lot of time..
Is there a way to get the count of the tables faster.In other words .is there a way to speed up the below query by using hints or any other means
select count(*) from TABLE_ABC
I know we can get the row count roughly by querying the ALL_TABLES dictrionary table but these numbers will not be accurate as we analyze the tables once a week..