How to get the rows count in a faster way for the tables that has billions of records:
Select count (*) from <t1> ; - The expected time to return results is longer here
select from dba_tables; -- it doesn’t help in real time scenario.. since it requires the stats to be generated on the table.. and that requires a longer time to complete.
Greatly appreciate your help on this.