Hi Jonathan,

As per your suggestion I created the indexes but it hasn't really helped the query execution time a lot and only a couple of indexes are being used. However, the execution time is still around 4 odd minutes. I have also attached the query plan for further review.

Indexes used by the query
IX_Activities_1 (You will notice that it is IX_Activities_5 as I already had one with that number)
IX_DealsToClients_1

Kindly, let me know what else can we do to improve it even further to reduce the execution time to 2 odd minutes...the way you've helped me out before.

Thanks again.