The optimizer in DB2 5 popular functions in a nutshell


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

  1. 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)
  2. 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.
  3. Read other  functions and  Best examples

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.