Oracle, MSSQL, DB2, et. al., are essentially like magic when it comes to making hopeless piles of SQL run quickly. This is because these engines have all ostensibly targeted the business people over the decades more than the tech people.
Features like dynamically optimizing queries as they return results [0,1,2] isn't something you chase if your audience is willing to rewrite the universe at the first sign of incongruity.
Features like dynamically optimizing queries as they return results [0,1,2] isn't something you chase if your audience is willing to rewrite the universe at the first sign of incongruity.
[0] https://learn.microsoft.com/en-us/sql/relational-databases/p...
[1] https://www.ibm.com/docs/en/i/7.5?topic=overview-adaptive-qu...
[2] https://apex.oracle.com/pls/apex/features/r/dbfeatures/featu...