Query Optimizer


Related Terms
Definition

The query optimizer is the component of a database management system that is used to analyze queries submitted to database server for execution, and then determine the optimal way to execute the query (Query plan).

The query optimizer cannot be accessed directly by users.

Instead, once queries are submitted to database server, and parsed by the parser, they are then passed to the query optimizer where optimization occurs.