The SQL Optimizer is a part of the kernel of the database system. It analyses SQL queries that are addressed to the database instance and selects the best search strategy for accessing the database tables.
See also:
Documentation about the SQL Optimizer