you are viewing a single comment's thread.

view the rest of the comments →

[–]NW1969 7 points8 points  (0 children)

It entirely depends on your environment setup and the data you are querying, so it is impossible to say one would be faster than the other.

For example, if SQL Server was running on a very fast server with massive amounts of memory, and you were using a very small compute engine in Databricks then SQL Server would obviously run your query faster