the user access the query optimizer directly.

queries are submitted to database server, and after passed to the query optimizer where optimization occurs.

the user has to specify the procedures needed to produce a result set.

the database system changes the left query into an efficient query plan.