Basic optimizer concepts, access path types. - **C2090-621: DB2 11.1 DBA for LUW** — RUNSTATS, EXPLAIN, optimization levels, optimizer configuration. - **C2090-312: DB2 12 for z/OS DBA** — Access path selection, Stage 1/Stage 2, PLANMGMT, REOPT, RUNSTATS strategies.