Hacker News new | ask | show | jobs
by nurettin 2979 days ago
A simple example would be "how to select groupwise maximum" where Postgres would respond well to a correlated subquery and Oracle would respond well to a window function and derived table. The engines and optimizations are different.