I have a large database having a total table count of more than 100, and in some tables, the total records count is more than 20 Cr. So I use Count() for each table it takes so much time to get the total record count of all tables. Can anyone help me with how can I get all the records count of all tables in less time?
Thank you.