Last updated on August 29th, 2020 at 09:56 am
- DDL Interpreter: It interprets the DDL statements and records the definitions in data dictionary.
- DML Compiler: It translates the DML statements in a query language into an evaluation plan consisting of low-level instructions that the query evaluation understands. It also performs query optimization which actually picks up the lowest cost evaluation plan from various alternatives.
- Query Evaluation Engine: It executes the low level instruction compiled by the DML compiler.