The Art of SQL Query Optimization

SQL is a declarative language; only the result of the query is specified. The exact steps to produce the result must be determined by the DBMS.