Comment by idiocrat

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

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