Query optimization doesn't work because SQL is declarative
2 points by jamii 5 months ago | 1 comment- idiocrat 5 months agoMaybe the "query optimization works because sql is set-oriented"?
The types of operations in SQL are limited to sets, therefore allowing certain optimizations.