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.
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.