In MySQL it's about 4 seconds vs. about 1.5 minutes. I believe MySQL is creating a temporary table with the entire contents of the subquery where as SQL Server's optimizer is doing something smarter.

File metadata and controls Preview Code Blame executable file · 59 lines (48 loc) · 2.51 KB Raw 46 47 48 49 50 51 53 54 55 56 57 58 59 # java-cli-bloop-sbt-mysql ...