I am facing some performance issues when trying to join two tables from different azure sql servers. My query is taking a whole minute to complete. One table contains around 1 million rows the second one around 200k.
Hi Balaji,
We don’t normally do this but recently have been asked to create threads when people come in on intercom. Here is a link he sent me to his profile of query and the intercom chat himself.
fc3b28ed-50e6-4432-a653-0ba4869b01d9.zip
https://app.intercom.io/a/apps/pwg3e6ch/inbox/inbox/2978390/conversations/23508804441