Query optimization doesn't work because SQL is declarative

Maybe the "query optimization works because sql is set-oriented"?

The types of operations in SQL are limited to sets, therefore allowing certain optimizations.