Query optimization doesn't work because SQL is declarative

Maybe the &quot;query optimization works because sql is set-oriented&quot;?<p>The types of operations in SQL are limited to sets, therefore allowing certain optimizations.