Indeed, SQL is tricky like that because there are plenty of performance consequences for a language that is meant to be declarative and optimized by a query pla

Indeed, SQL is tricky like that because there are plenty of performance consequences for a language that is meant to be declarative and optimized by a query planner. Unless you have realistic data in the test database the performance behavior of a query can be unpredictable. SQL is very leaky abstraction.