Optimizer group is responsible for developing Oracle's state of the art query optimizer. The query optimizer is often referred to as the brain of the database management system because it is the component that decides how to process SQL queries by building execution plans. Some of the optimizer areas include automatic statistics gathering, query transformation techniques, search algorithms and cost formulas to select access paths, join methods, join orders to produce the best performing execution plan for a SQL statement. The algorithms for efficient query processing encompass applications and areas like data warehousing, OLTP and non-traditional data processing (e.g. Text, Spatial, XML, JSON).
