Thanks Tresesco and Abhijit. Unfortunately, we cannot increase the hardware.
Do you think incremental loading is going to help? Incremental loading is useful when we are not able to execute the entire query and we break the dataset and concatenate the result. Because the query has returned and its just loading records I am somewhat doubtful.