DZone Database Zone
JOIN Elimination: An Essential Optimizer Feature for Advanced SQL Usage
The SQL language has one great advantage over procedural, object-oriented, and "ordinary" functional programming languages. The fact that it is truly declarative (i.e. a 4GL/fourth-generation programming language) means that a sophisticated optimizer can easily transform one SQL expression into another equivalent SQL expression, which might be faster to execute.
How does this work?
No comments:
Post a Comment