Skip to Content
0
Jan 22, 2021 at 12:18 PM

How to get SDI replication Virtual tables count with out using select count(*) from "VT_TABLE_NAME"?

176 Views Last edit Feb 01, 2021 at 10:20 AM 2 rev

Dear All,

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?

or

Suggest me any other way to get count with out using count(*) method?


Regards,

Deepthi