Please find the actual execution plan.

Please let me know for any recommendations and modifications in the query as posted earlier.

The logic is, we need to pull complete data from a table XXIST, where it fetches 70 billions of records every run (scheduled).

Awaiting for responses.

Have great times..