Query processing in Oracle DBMS.

ABSTRACTThis talk presents a broad overview of recent features in Oracle query processing including query optimization, parallel and serial executions, and analytics and OLAP. It describes Oracle's global query optimizer, which integrates logical transformation and cost-based physical optimization to allow an extensive set of possibly interdependent transformations to be performed in a cost based manner; it discusses the adaptive nature of the physical optimizer that uses feedback loop to improve upon its previous decisions. Some novel query execution techniques as well as Oracle's parallel shared-disk architecture are described. The talk outlines Oracle extension for analytics and OLAP features and their integration into the database engine. The challenges of building state-of-the-arts query optimizer and execution engine are highlighted.