Exact table count for all tables in a schema.
Hi all,
I am using Innodb storage engine for all the databases.Information_schema.tables gives only the approximate count of an table, as I am not able to get the exact row count for the all tables in a database.
Do we have any approach of getting the exact count for all tables in a database.
Apart from getting the table count separately for each table like "select count(*) from table xxx".
Thanks In Advance
Sreekanth
Subject
Views
Written By
Posted
Exact table count for all tables in a schema.
2064
September 13, 2019 01:53AM
815
September 13, 2019 09:43AM
754
September 16, 2019 11:15PM
653
September 17, 2019 10:07AM
675
September 19, 2019 12:24AM
683
September 19, 2019 09:38AM
722
September 20, 2019 04:04AM
594
September 20, 2019 09:50AM
730
September 20, 2019 10:03AM
799
September 20, 2019 12:45PM
645
September 22, 2019 11:51PM
674
September 23, 2019 10:21AM
693
September 24, 2019 10:45PM
640
September 25, 2019 11:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.