'A simple left join query taking lot of time for output
In Azure SYNAPSE I have two tables table A with 6 millions of records and Table B with 2 millions when I run a simple left join query it takes around 20 minutes to execute but when I run same join query in On premises SQL SERVER it gives output in 1 sec. I have round robin distribution in synapse and columns are indexed, What can be the reason for this issue?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|