At the heart of the DB2 engine is the DB2 Optimizer, or SQL Compiler as it is known. The SQL compiler is a program that converts static and dynamic SQL into code that is executable by the DB2 engine.
Also Read | DB2 DBA role and certification
The best 5 optimizer functions
- The optimizer code analyzes SQL and determines the best access plan (an access plan is what the DB2 engine executes to return the results to the program or user-interface that submitted the SQL)
- The access plan consists of methods and procedures that the DB2 optimizer has determined are necessary to provide the answer set to the requesting application.
- Read other functions and Best examples