How to improve a join between two huge tables, one tables contains 4 billion records and another contains 2 billion records in snowflake on L size warehouse. These join occurs when thoughtspot triggers a query on snowflake. Currently it is taking 4 mins. I want to bring it down to less than 10 secs. I tried doing clustering, QAS etc. The join is inner join and relation ship is one to many.