In SQL Server these queries will run in roughly the same time. In MySQL it's about 4 seconds vs. about 1.5 minutes.

MySQL Autopilot uses advanced machine learning techniques to accelerate HeatWave query performance and scalability in Oracle Cloud’s MySQL Database Service.