Best approach to compare HANA Tables

Hello All,

I have 2 tables with 100 columns each with same structure & I have 70 Million rows in each table.

I wanted to do a apple to apple comparisons to make sure the data is same b/w those 2 tables.. But the below Query taking lot of time.

Select * From T1 Minus select * from T2

Any faster way to achieve this ?

Br

Kiran K

Scroll to Top