Hi,

I think you can consider the option of partitioning the table since it has more than 1 billion records.In order to make use of partitions effectively, the query’s where clause should have the column information associated to partitions.

Thanks