choosing access paths, index usage, join methods 4. Stores the resulting access plan in the DB2 catalog (SYSPLAN/SYSPACKAGE tables)