Hope everyone are doing Good & Safe!
My question here is whenever we run select count(*) from table name on huge table taking more time and using some memory when I am running the query.
I want to compare count of virtual table and physical table whether it is matching or not? and real time replication is working fine or not?
I can get physical tables count from (SELECT "TABLE_NAME","RECORD_COUNT","SCHEMA_NAME" FROM "SYS"."M_TABLES").
The problem here is with out using select count(*) from "VT_<Table_name>", How to get the count of all virtual tables from particular schema? Is there any standard table in HANA to get count of virtual tables from particular schema?
Suggest me any other way to get count with out using count(*) method?